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