View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach[_6_] Otto Moehrbach[_6_] is offline
external usenet poster
 
Posts: 201
Default Number display in formula bar

Thanks Jim. That's what I thought it would be. Otto
"Jim Rech" wrote in message
...
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
"Otto Moehrbach" wrote in message
...
| Oops. The original number should be .320123. Otto
| "Otto Moehrbach" wrote in message
| ...
| 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
|
|
|
|