View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fellow Wanderer Fellow Wanderer is offline
external usenet poster
 
Posts: 14
Default Rounding on Entry

When I enter "2446921240995606" in a cell formatted as a number
and hit enter, the last digit is altered to a zero. the result I get is
"2446921240995600".

Is there a way to keep it from being changed without formatting it as text?