Why does the + character keep disapearing?

[MrFancypants82]

I don't know Excel at all and only wanted to use it because it keeps everything neat and organized. I have a column that displays the difference in received and verified inventory. Most of it reads 0, I have what is sent, but sometimes I'm short a piece or two and sometimes I received more than what they think they sent. I understand that 5 is a positive number and doesn't technically need the plus sign in front of it but I think it would read better if it did. How can I get Excel to stop deleting the plus sign when I type it in? In the end I want a column that reads like:
0
0
0
-3
0
+2
0
etc etc. Thanks!

[VBA Noob]

Maybe a custom format would work

[<0]"-"0;[>0]"+"0;General

or

+0;-0

or

+0.00;-0.00


VAB Noob

[MrFancypants82]

thanks, i apreciate your help and .+5 works so i guess i'll use that. Why does Microsoft have to make everything so complicated?

[VBA Noob]

They tried to implement a new software system at work and when we pointed out the bugs they would say it actually a feature

So depends on your point of view I guess

VBA Noob