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?

Show format in formula bar
 

No, you can't change the number formatting in the formula bar.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Native" wrote in message
oups.com...
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?