Number format to remove negative sign

[VBA_Newbie]

Hi folks,

Does anyone know how to create a custom number format to remove the negative sign when the cell is displayed. I still need Excel to treat the value as negative. I just need it to be displayed in graphs like a regular (non-negative) number. Thanks.

 

[Domski]

Hi,

Try this:

#,##0.00;#,##0.00

Dom

 

[Dutchy]

depends if you want decimal places etc. but if all your numbers are integers how about

0;0;0

 

[VBA_Newbie]

Thanks, that worked but I guess I should have been more specific with my first post. The numbers are precentages. For example, in my graphs it displays -11%. I need it to display 11%. The format you posted gets rid of the negative sign, but it doesn't display it as a percentage anymore, it shows 0.11

Any ideas?

 

[Mark W.]

See the Excel Help topic for "Create a custom number format".

 

[Dutchy]

0%;0%;0%

 

[Domski]

0%;0%

Dom

 

[VBA_Newbie]

Thank Dom and Dutchy...works great!