| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
"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. |
Threaded Mode
