View Single Post
  #1   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

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