View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default How do I stop numbers from rounding in Excel?

You could possibly do it by converting it to text with higher number of
decimal places and trimming away the trailing zeroes, but other parts
of the spreadsheet would then have to be modified if they rely on it
being a number.

If the quarter hours were converted to proper hh:mm format they would
display correctly, but again formulae elsewhere would probably have to
be amended.

Pete