View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joey Joey is offline
external usenet poster
 
Posts: 45
Default Numbers view different when clicked on cell

I have a data export that views correctly with numbers at two decimals
(12.56) but when I click on the cell - the number display with eight
decimals (12.561212230. i have tried changing the format globally but it
won't change. I can change them individually but was wondering what would
make this happen?

Jo