when I enter 5000 the spreadsheet shows 500. Why?
 

When I enter the number 5000 It comes up 500. any help out there? Thanks

Look under toolsoptionsedit and uncheck fixed decimal places


Regards,

Peo Sjoblom

"Pecaut lady" wrote:

When I enter the number 5000 It comes up 500. any help out there? Thanks

Check ToolsOptionsEdit and make sure the Fixed decimal box is unchecked.

--
HTH

Bob Phillips

"Pecaut lady" <Pecaut wrote in message
...
When I enter the number 5000 It comes up 500. any help out there? Thanks

Thank you so much!! You have been a great help.
--
Pecaut lady


"Peo Sjoblom" wrote:

Look under toolsoptionsedit and uncheck fixed decimal places


Regards,

Peo Sjoblom

"Pecaut lady" wrote:

When I enter the number 5000 It comes up 500. any help out there? Thanks