| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Typed number is always divided by 100 after pressing enter
Hello,
I can't figure this apparently simple problem out! I have never seen this before. When I type a number, say 100, it divide it by 100 and shows a "1". When I type 363636, it enters "3635.36". I set the format to number "000.00", and I still get this problem. What gives? Thanks for your help. John -- Soli Deo gloria! |
|
#2
|
|||
|
|||
|
Try...
Tools|options|Edit tab Uncheck that Fixed decimal box RF dude wrote: Hello, I can't figure this apparently simple problem out! I have never seen this before. When I type a number, say 100, it divide it by 100 and shows a "1". When I type 363636, it enters "3635.36". I set the format to number "000.00", and I still get this problem. What gives? Thanks for your help. John -- Soli Deo gloria! -- Dave Peterson |
|
#3
|
|||
|
|||
|
Dave,
Thanks. It that box was checked is beyond me! John "RF dude" wrote: Hello, I can't figure this apparently simple problem out! I have never seen this before. When I type a number, say 100, it divide it by 100 and shows a "1". When I type 363636, it enters "3635.36". I set the format to number "000.00", and I still get this problem. What gives? Thanks for your help. John -- Soli Deo gloria! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The number change from 1350 to 13.5 and Enter does not function properly | Excel Discussion (Misc queries) | |||
| When I enter a number in an empty cel, de cel returns the value d. | Excel Discussion (Misc queries) | |||
| You Must Enter A Number In This Cell | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| How do I enter a prefix number to a colum of numbers | Excel Worksheet Functions | |||
Linear Mode
