Convert text to number

[Serene]

Hi everyone,


I have imported some data from Access. However, I discovered some text field needs to be converted to numbers. How can I do this in the easiest way?


Thanks in advance

Serene

 

[kaushik03]

Hi Serene,


Try this:


=ABS(A1)


or


=INT(A1)*1


and drag it down to apply to the entire ranges.


Where A1 is your data (stored as text).


Regards,

Kaushik

 

[Hui]

Type 1 into a spare cell then copy the cell

Select the Column with suspect numbers

Paste Special,

Select Values & Multiply

Apply