| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. . . |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. . . |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. . . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| counting the number of instances of a string within another string | Excel Worksheet Functions | |||
| help with excel number string | Excel Discussion (Misc queries) | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| Why does Excel interpret 2/29 as Feb 1st? | Excel Discussion (Misc queries) | |||
Linear Mode
