View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Native
 
Posts: n/a
Default Show format in formula bar

Hello:

On some spreadsheets I have #'s in the billions added together in
cells. Sometimes it is difficult to verify the number is 10,000,000,000
because it shows up as 10000000000. My eyes get crossed counting the
zeros.

I'd love if the formula bar would show 10,000,000,000; however, can't
seem to find a way to do this. Is this possible?