| 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
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| 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) | |||
Hybrid Mode
