| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Office Professional Excel 2003
Cell format: recently my excel sheet cells will not format as instructed.
Inputing the number "3" is accepted as "0.03" when it should be "3" or "3.0". Why is this occurring and how can it be fixed? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Office Professional Excel 2003
Hi Dave
Try Tools/Options/Edit and see if "Fixed decimal places" is checked, if it is then unchecked. HTH Jean-Guy "Dave Scott" wrote: Cell format: recently my excel sheet cells will not format as instructed. Inputing the number "3" is accepted as "0.03" when it should be "3" or "3.0". Why is this occurring and how can it be fixed? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Office 2003 updates have screwed up Excel ! | Excel Discussion (Misc queries) | |||
| Loading Office 2003 Service Pack 2 conflicts with Excel Subtotal | Excel Worksheet Functions | |||
| I am running Excel 2003 from Office 2003 Professional | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Hybrid Mode
