Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am using Exell 2003, when i enter a number it appears as a 2 decimal place
fraction, rather than a full number. The work sheet was created, originally in Office 97 |
#2
![]() |
|||
|
|||
![]()
Are you saying that the number is correct, just rounded to two decimal
places? If so, reformat the cell(s) as General. If you mean say 100 is showing as .01, this sounds like Fixed Decimal. Go to menu ToolsOptionsEdit and uncheck the Fixed Decimal box. -- HTH Bob Phillips "G4" wrote in message ... I am using Exell 2003, when i enter a number it appears as a 2 decimal place fraction, rather than a full number. The work sheet was created, originally in Office 97 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I select hiding a column as a conditional formatting? | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Conditional formatting applicable to entire column | Excel Worksheet Functions | |||
Conditional Formatting, reference another column | Excel Worksheet Functions | |||
Conditional formatting row if cell value in certain column is even | Excel Worksheet Functions |