Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I display $1,243,597 as $1,244 and $(324,567) as $(325)?
I've created a work around by creating a positvie and a negative custom
number format under format cells but I haven't been able to create one custom format that works for both positive and negative numbers that can be applied to a range of cells. There must be an easier way. I want to be able to highlight a number of cells and have it automatically round those cells to the nearest thousand and drop the ,000 from $989,000 so it displays as $989. |