when I write "+0", excel writes "-"

[learning_grexcel]

Hi,
When I feed number into excel like "+0", in some cell it writes as "0" and in some cell it writes as "-". Actually I want 0, not -

 

[Richard Schollar]

Just change the numer formatting of the cell to whichever format you want - General should format +0 as 0

 

[learning_grexcel]

thanks
what i shall do if I need "-" when I type "+0"?

 

[MrKowz]

If you want the "-" when the value 0 is in a cell, you can either make it accounting format with no dollar symbol. Or you can give it the custom number format:

General;General;"-"

Although I'm kind of particular to putting a couple of spaces after the "-" to bring it off the edge of the cell:

General;General;"-"??

 

[cjcobra]

if you put an apostrophe " ' " in front of whatever you put into a cell, it will not use it as a formula, just text

 

[learning_grexcel]

If you want the "-" when the value 0 is in a cell, you can either make it accounting format with no dollar symbol. Or you can give it the custom number format:

General;General;"-"

Although I'm kind of particular to putting a couple of spaces after the "-" to bring it off the edge of the cell:

General;General;"-"??

Thank you but I can't understand what you mean........

 

[MrKowz]

Right click on the cell and go to Format Cells. In this window, make sure you are on the "Number" tab. Under category, click on "Custom". This is where you can define a custom number format. The two pieces of code I supplied are two separate custom number formats that will show a "-" for a value of 0. Try each of them and see which one you like best (the second one will just move the "-" to the left two spaces so it isn't right on the edge of the cell.)