Show format in formula bar

N

Native

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?
 
C

Chip Pearson

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
 
Top