ExcelBanter - 0% = blank

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - 0% = blank (https://www.excelbanter.com/excel-programming/321448-0%25-%3D-blank.html)

broogle

0% = blank

Is there any format to make the cell equal to blank if the value = 0%.
Thanks

Bob Phillips[_7_]

0% = blank

Menu ToolsOptions and on the View tab, uncheck the Zero Values box.

--
HTH

Bob Phillips

"broogle" wrote in message
oups.com...
Is there any format to make the cell equal to blank if the value = 0%.
Thanks

Rob van Gelder[_4_]

0% = blank

Custom Number Format:

0%;-0%;

--
Rob van Gelder - http://www.vangelder.co.nz/excel

"broogle" wrote in message
oups.com...
Is there any format to make the cell equal to blank if the value = 0%.
Thanks

Tom Ogilvy

0% = blank

0%;-0%;;@

format=Cells, Number tab, put in Custom.

--
Regards,
Tom Ogilvy

"broogle" wrote in message
oups.com...
Is there any format to make the cell equal to blank if the value = 0%.
Thanks

broogle

0% = blank

Thanks a lot!!!

Tom Ogilvy wrote:
0%;-0%;;@

format=Cells, Number tab, put in Custom.

--
Regards,
Tom Ogilvy

"broogle" wrote in message
oups.com...
Is there any format to make the cell equal to blank if the value =
0%.
Thanks

All times are GMT +1. The time now is 07:18 AM.