Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Why would Excel default to a display of (example) 0.03 when the number 3 is
entered in a cell? When the Format Cells dialog box is opened, the format shows as General. This happens on every new and existing workbook on a particular PC. Could there be a setting somewhere or is it a fault in the program? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Correct the setting at:
<Tools <Options <Edit tab, And *Uncheck* "Fixed Decimal Places". -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "kat0301" wrote in message ... Why would Excel default to a display of (example) 0.03 when the number 3 is entered in a cell? When the Format Cells dialog box is opened, the format shows as General. This happens on every new and existing workbook on a particular PC. Could there be a setting somewhere or is it a fault in the program? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How to apply same format of referenced cell in Excel | Excel Discussion (Misc queries) | |||
cell format for date/time in same cell excel 2003 | Excel Worksheet Functions | |||
How do I set Excel cell format to "Text" from VB.NET? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |