ExcelBanter - formula to change 1 to a / and still add

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula to change 1 to a / and still add (https://www.excelbanter.com/excel-worksheet-functions/34193-formula-change-1-still-add.html)

kiddie

formula to change 1 to a / and still add

formula to change 1 to a / and .50 to O and add up correctly

Ron Rosenfeld

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

All times are GMT +1. The time now is 01:34 AM.