Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to display just number and not text | Excel Discussion (Misc queries) | |||
how to display rounded number in a cell w/formula | Excel Discussion (Misc queries) | |||
DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS | Excel Discussion (Misc queries) | |||
Formula to display the row number above? | Excel Worksheet Functions | |||
display total above certain number and display | Excel Discussion (Misc queries) |