| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Cell
I need to format a column of cells to show any negative figures as just 0
(zero) can this be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Cell
Try this custom format code:
0;"0" Regards, Stefi Al ezt Γ*rta: I need to format a column of cells to show any negative figures as just 0 (zero) can this be done? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Cell
That's great, when I format the whole column, it takes away the currency
format Β£123.123 for those that are not negative numbers - is there a way to stop that? "Stefi" wrote: Try this custom format code: 0;"0" Regards, Stefi Al ezt Γ*rta: I need to format a column of cells to show any negative figures as just 0 (zero) can this be done? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Cell
Try this format code:
[$Β£-809]# ##0.000,"0" You can modify the first part (before the comma) as you like, "0" is the one that supresses negative values. Stefi Al ezt Γ*rta: That's great, when I format the whole column, it takes away the currency format Β£123.123 for those that are not negative numbers - is there a way to stop that? "Stefi" wrote: Try this custom format code: 0;"0" Regards, Stefi Al ezt Γ*rta: I need to format a column of cells to show any negative figures as just 0 (zero) can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| cell format - remove cell format pattern without effecting colors | Excel Discussion (Misc queries) | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Linear Mode
