Custom Number Format

S

shternm

I created a custom number format #,##0,_);(#,##0,) that rounds number
to thousands but it also shows 0 as blank. I need a format that als
shows "0" as "0".

Thanks for your help
 
T

Trevor

#,##0,_);(#,##0,);0

the third position is for the format for zeros, so adding ;0 to your format
should take care of it.

However, make sure your setting on Tools->Options->View->zero values has a
check in it.
 
S

shternm

That works, but 0 is offset all the way to the right of the cel
compared to other numbers and that makes it look sloppy. I tried "0
but it didn't move it. Is there a way to realign it?


Thanks
 
J

JE McGimpsey

Use

#,##0,_);(#,##0,);0_)

The "_" character tells the display engine to add enough space to
accommodate the following character (in this case the right paren)
 
Top