Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting 11001981003213 as text..
11001981003213 is a serial number. I'm an Access Programmer running
automation to Excel. This long serial number, even when formatted as text on the Auto_Open event, displays as scientific notation. Is there an Excel setting to ensure it appears as text? TIA - Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
Text formatting | Excel Worksheet Functions | |||
Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) | |||
Formatting text.... | Excel Worksheet Functions |