ExcelBanter - how can i hide digit 0 after putting any equation

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

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

- - how can i hide digit 0 after putting any equation (https://www.excelbanter.com/excel-worksheet-functions/22345-how-can-i-hide-digit-0-after-putting-any-equation.html)

Hozefa

how can i hide digit 0 after putting any equation

how can i hide digit 0 in cell after putting any equation?

--
Hozefa N Jhabuawala

º¼ÖÝÈË

tool--option--view--zero

Bob Phillips

You could also use conditional formatting.

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Hozefa" wrote in message
...
how can i hide digit 0 in cell after putting any equation?

--
Hozefa N Jhabuawala

All times are GMT +1. The time now is 09:35 AM.