![]() |
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 |
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 |
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