View Single Post
  #1   Report Post  
Hari Prasadh
 
Posts: n/a
Default Custom Formatting a number

Hi,

I can do the following using a helper cell in conjunction with IF formula
but I dont/cannot do it that way for the present purpose.

In B4 if a cell displays zero it should display as - NULL - but if it is
some number like - 32,567 - then it should display 32,567 as it is.

Can this be achieved through custom formatting. Please suggest.

Please note B4 contains dollar amounts.
--
Thanks a lot,
Hari
India