| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
cell shows 20. Formula shows 20. why not 540/27
A cell shows 20. Formula bar shows 20. Formula bar should show 540/27.
How can I make the formula bar show the example formula 540/27? |
|
#2
|
|||
|
|||
|
The cell must contain the value 20 hardcoded and not a formula. Type =540/27
in the cell and then the formula bar will show =540/27 in it and 20 in the cell. "griswold" wrote: A cell shows 20. Formula bar shows 20. Formula bar should show 540/27. How can I make the formula bar show the example formula 540/27? |
|
#3
|
|||
|
|||
|
It sounds like you're formatted as number; try switching the cell format to
General: right-click on cell, format cell, number, general. "griswold" wrote: A cell shows 20. Formula bar shows 20. Formula bar should show 540/27. How can I make the formula bar show the example formula 540/27? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Some text shows in the formula bar but not in the cell. | Excel Discussion (Misc queries) | |||
| need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| looking for a formula | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
