ExcelBanter - replacing 0 with blank

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

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

- - replacing 0 with blank (https://www.excelbanter.com/excel-programming/278825-replacing-0-blank.html)

Sandy Ferguson

replacing 0 with blank

Further to my previous message I kept trying & GOT IT TO WORK.
In my particular case
IF((B2:M32 0),B2:M32*3.936996," ")
This changes my old rain charts measured in 1/100 of an inch to
millimetres & leaves the blanks blank rather than replacing them with
0

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