| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
typed numbers entered in cell wrong
I typea number in a cell and it appears divided by 10 i.e type 90 enter amd
..9 appears in cell |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
typed numbers entered in cell wrong
Try this:
From the Excel main menu: <tools<options<edit tab Uncheck: Fixed decimal places Does that help? *********** Regards, Ron XL2002, WinXP "Fred J" wrote: I typea number in a cell and it appears divided by 10 i.e type 90 enter amd .9 appears in cell |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
typed numbers entered in cell wrong
Go to the Tools menu, choose Options, then the Edit tab. There,
uncheck the "Fixed decimal" setting. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Fred J" <Fred wrote in message ... I typea number in a cell and it appears divided by 10 i.e type 90 enter amd .9 appears in cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
