unknown format

Hi there,

ive been sent an excel file which has thousands of lines of data.

Unfortunately they are in the attached format.

Is there a way of converting the data into excel properly in order for formlua's to wrk against them

thanks
excel help.xls

Hi Moe1986,

This is "Test box" , You can find one in developer TAB -> Insert ->Text Box Active Control

Punnam

thanks Punnam,

is there a way of converting these to normal number format?

I have thousands of lines and I don't want to be copying and pasting one at a time!

hi moe1986,

Sorry to say, i think can be done with the help of VBA , i am not having knowledge of VBA , hope other forum member could be helpful
I suggest you change the tile from "Unknown Format " to "Convert text Box to cell" or "Copy and paste data from text box to cell"

Punnam

thanks Punman, I'll repost it in the VBA section with an updated description