| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
show value as text not scientific notation
When we export for SQL servers and other sources, we frequently run into the
problem the text fields coming down with "E's" and numerics contained within them (such as "26E13", which is one of our item numbers, not numeric - should be text) comes down as "2.60E+13" under general setting in cell formatting. If you try to convert to text, it will show "26000000000000". Anybody suggest possible solutions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hex numbers displayed in scientific notation when importing text f | Excel Discussion (Misc queries) | |||
| Formatting as TEXT as opposed to scientific notation | Excel Discussion (Misc queries) | |||
| Scientific notation in text cells | Excel Discussion (Misc queries) | |||
| Using scientific notation in TEXT() function | Excel Worksheet Functions | |||
| Long numbers show up as Scientific Notation | Excel Discussion (Misc queries) | |||
Threaded Mode
