Numeric Data Entry problem

[NukeTony]

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.

 

[Pete_UK]

On your user's machine, click on Tools | Options | Edit tab and then
UNCHECK fixed decimal (about half-way down).

Hope this helps.

Pete

 

[Dave Peterson]

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.