T
Trevor
How can I format $123,456 to display as $123,500.
(Negative numbers would be in parens and red.)
TIA.
(Negative numbers would be in parens and red.)
TIA.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Go to FORMAT / CELLS / NUMBER and select "Custom."
Add the following custom format in the "Type" field:
($* #,##0._);[Red]($* #,##0.)
Add the following custom format in the "Type" field:
($* #,##0._);[Red]($* #,##0.)
T
Trevor
When I use that format, I get:
$ 123,456.
$ 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.
.
D
Domenic
Trevor said: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!
G
Guest
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
Thank you
Enterprise Project Consultin