| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number display in formula bar
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number display in formula bar
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 | | | | |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 | | | | |
| Reply |
| 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) | |||
![Otto Moehrbach[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
