Home |
Search |
Today's Posts |
#1
|
|||
|
|||
when I enter 5000 the spreadsheet shows 500. Why?
When I enter the number 5000 It comes up 500. any help out there? Thanks
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
Some exported records do not show on spreadsheet | Excel Worksheet Functions | |||
I need to setup a spreadsheet to enter data to from my findings o. | Excel Discussion (Misc queries) | |||
I need to setup a spreadsheet to enter data to from my findings o. | Excel Discussion (Misc queries) | |||
Applying Existing Password to New Spreadsheet | Excel Discussion (Misc queries) |