View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brian17 Brian17 is offline
external usenet poster
 
Posts: 9
Default How to show repeating decimals line

Hi all, is there a way to show the line over the repeating decimal?

For example, if I change a cell to a decimal format, type in 1/3 and press
enter I get 0.333333333etc. If I were handwriting it I could represent the
decimal as 0.3 with a line over the 3. Is there a way to do that in Excel for
repeating decimals? There are other fractions that when converted are
repeating decimals as well.

Thanks!
-Brian