ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   typed numbers entered in cell wrong (https://www.excelbanter.com/excel-discussion-misc-queries/89942-typed-numbers-entered-cell-wrong.html)

Fred J

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

Ron Coderre

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


Chip Pearson

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





All times are GMT +1. The time now is 09:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com