| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula to change 1 to a / and still add
formula to change 1 to a / and .50 to O and add up correctly
|
|
#2
|
|||
|
|||
|
On Wed, 6 Jul 2005 22:58:02 -0700, kiddie
wrote: formula to change 1 to a / and .50 to O and add up correctly Since you are wanting to change the display of a cell, you might be better off changing the format: Select the cells. Format/Cells/Number Custom Type: [=0.5]O;[=1]\/;General --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
