Format

[88mack]

OK...easy question that I forgot the answer to. In a financial report I want to indicate that all numbers are in ($000). Everytime I try to format the cell it goes back to $0. Im pretty sure its a custom format but cant remember what I used to use. Thanks

 

[MrKowz]

OK...easy question that I forgot the answer to. In a financial report I want to indicate that all numbers are in ($000). Everytime I try to format the cell it goes back to $0. Im pretty sure its a custom format but cant remember what I used to use. Thanks

Apply the custom number format:

$000

 

[88mack]

Too easy ...thanks for the help!

 

[MrKowz]

Too easy ...thanks for the help!

Thanks for the feedback.
Cheers!