Microsoft Office Forums - View Single Post - Formula to hide '0' from blank referenced cells

Thread: Formula to hide '0' from blank referenced cells

View Single Post

Old

05-08-2014, 02:16 AM

formuladummy formuladummy is offline

formuladummy is offline

formuladummy uses Windows 7 64bit

Windows 7 64bit formuladummy uses Office 2013

formuladummy uses Office 2013

Office 2013

Novice

The original poster

Join Date: May 2014

Posts: 2

formuladummy is on a distinguished road

Default

Thanks.

The formula worked for the first cell and pulled in the column header, but when I changed it to an array formula (using CTRL+SHIFT+ENTER) to reference the whole column, it crashed my whole system. This didn't happen for the other columns.

Is there another option?

Reply With Quote