| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
typing #1 becomes #10
When i go to type the number 1 in a spreadsheet it comes up as a ten, or 2
becomes 20!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
typing #1 becomes #10
Check it's really 10, rather than 1.0
It might be that you've for fixed length digits turned on. If not - reply and I'll try to help more. "tenbobblind" wrote: When i go to type the number 1 in a spreadsheet it comes up as a ten, or 2 becomes 20!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
typing #1 becomes #10
One to check is auto-correct, has it been set to automatically correct 1 to 10
Mike "tenbobblind" wrote: When i go to type the number 1 in a spreadsheet it comes up as a ten, or 2 becomes 20!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
typing #1 becomes #10
One more to check
Tools|Options|Edit tab|Uncheck fixed decimals tenbobblind wrote: When i go to type the number 1 in a spreadsheet it comes up as a ten, or 2 becomes 20!!! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where has my typing bar gone? | Setting up and Configuration of Excel | |||
| TYPING KARAOKE PGS NEED HELP | New Users to Excel | |||
| This has kept me up typing for hours... | Excel Discussion (Misc queries) | |||
| Help typing formula | Excel Worksheet Functions | |||
| Text Typing | Setting up and Configuration of Excel | |||
Linear Mode
