"Bernie Deitrick" wrote:
Make that:
$#,###,;$(#,###,)
I'm just not paying attention today <g
HTH,
Bernie
MS Excel MVP
"clnickson" wrote in message
...
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.
|