how to change formula bar settings

G

Guest

I want to know how to change the font that appears in the formula bar. Also
is it possible for the formula bar to mirror the display on the cell. For
eg., the entry in the cell is 2,520 but appears as $2,520 by using the
currency format. Is it possible for the formula bar also to display the
number as $2,520....it usually displays 2520.
 
G

Gord Dibben

1. Tools>Options>General. Change standard font here. Note: this will affect
row and column headers also on all new workbooks.

2. No. The formula shows only what is in the cell, not what the cell is
formatted to.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array formula lock-up 1
Convert number to text as displayed 3
How do I add the formula bar? 2
how to scroll while in formula bar (Excel 2007) 0
Help needed 0
Formula appearing as Value in Formula Bar 1
hit F2, want the color coded formula to appear in formula bar not 1
Help to resove this problem. 1

Top