Hi,
I have a budget spreadsheet where I would like to display values rounded to the nearest 1000, without changing the actaul value. I want to keep the accounting format with the $ sign and ( ) for negative numbers. An example $8,965 I want to display as $9,000. If it's negative $(8,965) then as $(9000). The value needs to stay as the 8965.
Thanks for the help!
Last edited by zpenacho; 02-19-2018 at 10:04 PM. Reason: marked as solved
After selecting the Accounting format, in the Format Cells dialog box, click Custom and change #,##0.00 to ##0, (with comma on the right) in two places. The Custom format should be:
_($*##0,_);_($* (##0,);_($* "-"??_);_(@_)
Thank you for the reply! That only shows a 9 (with a bunch of # signs in front of it), I would like it to show 9000. Is that possible?
Sorry, I misread your requirements, which you stated very clearly.Originally Posted by zpenacho
If you want a modified form of the Accounting format, try the following Custom format (also correcting a critical typo in my previous posting):
_($* #,##0,",000"_);_($* (#,##0,",000");_($* "-"_);_(@_)
But your example is not in Accounting format. There is no comma; the "$" is not preceded by spaces so it is always on the left side of the cell.
For your example, try the following Custom format:
_($#,##0,",000"_);_($(#,##0,",000");_($"-"_);_(@_)
The first one you gave is exactly what I needed, thank you so much! (sorry, I got sloppy w/ the commas and $ signs!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks