Custom Format

[Trevor]

How can I format $123,456 to display as $123,500.
(Negative numbers would be in parens and red.)

TIA.

 

[Guest]

Go to FORMAT / CELLS / NUMBER and select "Custom."
Add the following custom format in the "Type" field:
($* #,##0._);[Red]($* #,##0.)

 

[Trevor]

When I use that format, I get:
$ 123,456.

-----Original Message-----
Go to FORMAT / CELLS / NUMBER and select "Custom."
Add the following custom format in the "Type" field:
($* #,##0._);[Red]($* #,##0.)

-----Original Message-----
How can I format $123,456 to display as $123,500.
(Negative numbers would be in parens and red.)

TIA.
.

.

 

[Domenic]

How can I format $123,456 to display as $123,500.
(Negative numbers would be in parens and red.)

TIA.

Hi Trevor,

I don't know if that can be done using Custom Format, but does this help?

Assuming A1 has your value:

=CEILING(A1,500)

Hope this helps!

 

[support]

I am from the MS Excel support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consultin