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