| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting numberformat for -ve numbers
Hi,
I want to set the numberformat property such that if the value in cell in whole sheet is a -ve number then it should be displayed in red color with brackets around it. What should I set the numberformat property to ?? Is there a list of values available that numberformat can be set to ? Thanks, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting numberformat for -ve numbers
It's a custom format,
0.00;[Red](0.00) (it's a variation on one of the standard formats, but with the addition of the brackets) bsobaid wrote: Hi, I want to set the numberformat property such that if the value in cell in whole sheet is a -ve number then it should be displayed in red color with brackets around it. What should I set the numberformat property to ?? Is there a list of values available that numberformat can be set to ? Thanks, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting numberformat for -ve numbers
Thanks, and how do I say to put comma as a thousand separator ??
" wrote: It's a custom format, 0.00;[Red](0.00) (it's a variation on one of the standard formats, but with the addition of the brackets) bsobaid wrote: Hi, I want to set the numberformat property such that if the value in cell in whole sheet is a -ve number then it should be displayed in red color with brackets around it. What should I set the numberformat property to ?? Is there a list of values available that numberformat can be set to ? Thanks, |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting numberformat for -ve numbers
You can find all that you need by just formatting a cell as a given
format, but #,##0.00 would give the comma bsobaid wrote: Thanks, and how do I say to put comma as a thousand separator ?? " wrote: It's a custom format, 0.00;[Red](0.00) (it's a variation on one of the standard formats, but with the addition of the brackets) bsobaid wrote: Hi, I want to set the numberformat property such that if the value in cell in whole sheet is a -ve number then it should be displayed in red color with brackets around it. What should I set the numberformat property to ?? Is there a list of values available that numberformat can be set to ? Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spread numbers by setting up a Min and Max | Excel Worksheet Functions | |||
| setting up random number generator for lotto numbers | Setting up and Configuration of Excel | |||
| setting up excell to add and subtract numbers. | Excel Discussion (Misc queries) | |||
| Setting round numbers for the scale | Charts and Charting in Excel | |||
| Setting NumberFormat within a VBA Module | Excel Discussion (Misc queries) | |||
Linear Mode
