| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Excel's Auto Formatting
In Excel 2000, if you have a text of more than 15 digits
(eg: "12345678912345678912345"), excel automatically changes this into exponential. If you have leading zeros in a cell (eg: 0001), excel strips the leading zeroes. Without changing the cell format, how do I disable excel's automatic cell value formatting. Is there registry setting that needs to be set? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel's 2003 Auto Recover Feature | Excel Discussion (Misc queries) | |||
| How does one disable Auto-Formatting of dates? | Excel Discussion (Misc queries) | |||
| Disable auto-formatting dates.... GRRR! | Excel Discussion (Misc queries) | |||
| Disable auto-formatting dates.... GRRR! | Excel Worksheet Functions | |||
| Disable auto editor formatting | Excel Programming | |||
Threaded Mode
