Number display in formula bar

O

Otto Moehrbach

Excel 2002, WinXP
In VBA I calculate a number as .32123. The code rounds that number to 3
places and puts the number in a cell that is formatted to Percentage.
The cell displays 32.0%.
But the formula bar displays 32%.
Question: Is there any way to get the formula bar to display the same as
the cell, 32.0% ?

Thanks for your help. Otto
 
J

Jim Rech

You cannot format the formula bar. It displays what is really in the cell.
What you see in a cell itself can be formatted so is not necessarily the
same.

--
Jim Rech
Excel MVP
| Oops. The original number should be .320123. Otto
| | > Excel 2002, WinXP
| > In VBA I calculate a number as .32123. The code rounds that number to 3
| > places and puts the number in a cell that is formatted to Percentage.
| > The cell displays 32.0%.
| > But the formula bar displays 32%.
| > Question: Is there any way to get the formula bar to display the same
as
| > the cell, 32.0% ?
| >
| > Thanks for your help. Otto
| >
| >
|
|
 
Top