View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NukeTony NukeTony is offline
external usenet poster
 
Posts: 1
Default 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