Numeric Data Entry problem
In a shared Excel spreadsheet, one users computer when he enters a number it
is displayed as the number divided by 100. So he enters 5, it is displayed and recorded as 0.05. On my computer, I open the same file (shared) and enter 5 in the same cell and it is displayed and entered as 5. Any thoughts? I've worked with the format issue and the macros and have found nothing that would cause this to occur. -- NukeTony |
Numeric Data Entry problem
On your user's machine, click on Tools | Options | Edit tab and then
UNCHECK fixed decimal (about half-way down). Hope this helps. Pete On May 2, 2:34*pm, NukeTony wrote: In a shared Excel spreadsheet, one users computer when he enters a number it is displayed as the number divided by 100. *So he enters 5, it is displayed and recorded as 0.05. *On my computer, I open the same file (shared) and enter 5 in the same cell and it is displayed and entered as 5. * Any thoughts? *I've worked with the format issue and the macros and have found nothing that would cause this to occur. -- NukeTony |
Numeric Data Entry problem
In xl2003 menus:
Tools|Options|Edit tab|Uncheck Fixed Decimals. It's nice for the accountancy types who don't want to waste time typing decimal points. NukeTony wrote: In a shared Excel spreadsheet, one users computer when he enters a number it is displayed as the number divided by 100. So he enters 5, it is displayed and recorded as 0.05. On my computer, I open the same file (shared) and enter 5 in the same cell and it is displayed and entered as 5. Any thoughts? I've worked with the format issue and the macros and have found nothing that would cause this to occur. -- NukeTony -- Dave Peterson |
All times are GMT +1. The time now is 03:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com