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.

1. ToolsOptionsGeneral. 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

On Mon, 29 Aug 2005 08:22:05 -0700, eccentric
wrote:

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.