View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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. . .