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. |
#2
|
|||
|
|||
cl,
Use a custom format of $#,###, 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. |
#3
|
|||
|
|||
Oops, missed your negative requirement. Use a custom format of
$#,###,;($#,###,) 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. |
#4
|
|||
|
|||
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. |
#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. |
#6
|
|||
|
|||
Thank you...I don't know why I couldn't figure out how to do pos & neg. -
this makes sense now that I see it here. Do you know how to save custom number formats so when you open a new worksheet you can find the same format again? I've found that in every worksheet I have to add the custom number format. "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. |
#7
|
|||
|
|||
I think if you add that format to a cell in your workbook template file (Book.xlt, in your startup
folder), it should be available when you open a new workbook. Same should hold for Sheet.xlt. HTH, Bernie MS Excel MVP "clnickson" wrote in message ... Thank you...I don't know why I couldn't figure out how to do pos & neg. - this makes sense now that I see it here. Do you know how to save custom number formats so when you open a new worksheet you can find the same format again? I've found that in every worksheet I have to add the custom number format. "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|