How to interpret string as a number in Excel 2007 ?
 

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. . .

How to interpret string as a number in Excel 2007 ?
 

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

"AntonAL" wrote:

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. . .

How to interpret string as a number in Excel 2007 ?
 

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..


"AntonAL" wrote:

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. . .

How to interpret string as a number in Excel 2007 ?
 

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)
--
** John C **

"AntonAL" wrote:

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. . .