Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
In xl2003 menus:
Tools|Options|Edit tab Uncheck fixed decimal places It's nice for accounting types. Not so nice for the rest of us. Bill Helbron wrote: I just went to enter new some new data and noticed that when I expanded my date column, began entering the new data in the next column, the format changed from, e.g. "87" to "0.87". I tried changing the FormatCellsNumber to "General" and the result appears as "0.87". Likewise, "General" appears as "0.87", "Currency" appears as "$.087", etc. What's happened here? Thanks! Bill -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
PROBLEM:How to squeeze 2 Page sized Chart in Excel 2000 & embed in Word 2000 and print from Word to fit one page ??? | New Users to Excel | |||
Excel 2000 - Format Cell - Custom | Excel Worksheet Functions | |||
I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
Format Problem - Very urrgent - Xp to 2000 | Excel Discussion (Misc queries) | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions |