| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent conversion of numeric text string to scientific notation
If i type, paste, edit in situ, or text-to-column large numeric string like:
0342737749549075 it will be converted to 3.42738E+14 completely against my will. The Cell is set as 'text' (What part of 'text' does Excel not understand??) I'm on Mac, so that could also be the problem. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Prevent conversion of numeric text string to scientific notation
Increase the width of the column as needed. HTH Otto
"StuckWithExcelAlas" wrote in message ... If i type, paste, edit in situ, or text-to-column large numeric string like: 0342737749549075 it will be converted to 3.42738E+14 completely against my will. The Cell is set as 'text' (What part of 'text' does Excel not understand??) I'm on Mac, so that could also be the problem. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show value as text not scientific notation | Excel Discussion (Misc queries) | |||
| How to prevent General format from using scientific notation? | Excel Discussion (Misc queries) | |||
| Prevent Scientific Notation | Excel Discussion (Misc queries) | |||
| Scientific notation in text cells | Excel Discussion (Misc queries) | |||
| Disable Scientific Notation conversion | Excel Worksheet Functions | |||
Linear Mode
