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

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

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

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