Custom format

[Scottmk]

Hi,
Is there anyway to create a custom format that returns "-" for a blan
cell?
Thank

 

[Dave Peterson]

I don't think so, but maybe you could use a helper cell and hide the original:

=if(a1="","-",a1)

 

[Soo Cheon Jheong]

Hi,


1) #;-#;"-"
2) 0;-0;"-"
3) #,##0;-#,##0;"-"
..
..
..

 

[Dave Peterson]

This worked for you when the cell was empty?

Hi,

1) #;-#;"-"
2) 0;-0;"-"
3) #,##0;-#,##0;"-"
.
.
.