| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel number entry
opened a spreadsheet today and when entering a number i get .xx, that is when
i enter 5 in a cell it shows as .05 Any suggestions on how to fix? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel number entry
Tools Options... Edit clear the fixed decimal checkbox
-- Gary''s Student - gsnu200810 "redmond" wrote: opened a spreadsheet today and when entering a number i get .xx, that is when i enter 5 in a cell it shows as .05 Any suggestions on how to fix? thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel number entry
Try,
Tools|Options|Edit Un-check 'fixed decimal places' Mike "redmond" wrote: opened a spreadsheet today and when entering a number i get .xx, that is when i enter 5 in a cell it shows as .05 Any suggestions on how to fix? thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel number entry
hi
2003.... on the menu bar...Toolsoptionsedit tabuncheck fixed decimal places 2007... i think....office buttonexcel optionsect. regards FSt1 "redmond" wrote: opened a spreadsheet today and when entering a number i get .xx, that is when i enter 5 in a cell it shows as .05 Any suggestions on how to fix? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop repeat entry of a number in the same Excel column | Excel Worksheet Functions | |||
| How do I stop Excel from changing last digit in a number entry? | New Users to Excel | |||
| number entry | New Users to Excel | |||
| How do I start an Excel entry with then number 0? | Excel Discussion (Misc queries) | |||
| number entry | Excel Worksheet Functions | |||
Linear Mode
