Custom format Numbers

J

jchick0909

hello,

I am using the following custom format for thousands, but I also need to
show a dash ie "-" if the value is a zero, thanks for your help!!

#,###,
 
N

Niek Otten

Use something like

#,###,;-#,###,;"-"

Anyway, the 3rd entry (entries separated by semicolons) defines the
appearance of a zero value

1. positive number
2. negative number
3. zero
4. text
 
F

Fred Smith

What do you want when the cell is negative? The format of a custom format
is:
positive;negative;zero;text

So you want something like:
#,##0,;-#,##0,;-

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top