How to interpret string as a number in Excel 2007 ?

[AntonAL]

Hello everyone!

I've been a little confused. . .
I have imported a log, that contains a processor workload. The numbers have
a format, like this:
27.314168336673351

Because this "number" have '.' as decimal separator, Excel interprets it as
string.

Does Excel have any function or format option to interpret this as number ??

A have played with Right click--> "Format Cells...", but it does not helps
me. . .

 

[Joel]

If excel is interprets the number as a string the are invisible character at
the beginning and/or end of the string

 

[Sheeloo]

Check if the cell has anything other than the numbers shown by you.

Apparently the value is imported as a Text..

Enter 1 anywhere in your sheet, Copy it, select your cell with the number
and RIGHT-CLICK|Paste Special|Multiply
This should convert your text to number..

 

[John C]

Not sure, but it could also be that since there are more than 15 significant
digits, xl is thinking it can't be a number, because too many characters,
therefore, must be a string..... (Yes, I could be wrong on this)