View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
barry barry is offline
external usenet poster
 
Posts: 116
Default Rounding on Entry

no there is not... excel only takes 15 digits for numbers.. after that.. no
choice but text..


"Fellow Wanderer" wrote:

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?