| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2000 Cell Format Problem
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 |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel 2000 Cell Format Problem
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
