Formatting Cells - Adding "+" to a number

[Broker1]

Hi all,

I have created a spreadsheet which utilizes a simple vlookup to a second worksheet and trying, unsuccesfully, to add the "+" sign in front of a positive number which refereces a positive number in the other worksheet. Is this possible? I hope the question makes sense.

I am well-aware of the custom format option, but I am not able to create a custom format which allows me to accompish this.

For example, I am hoping for the final product to appear as follows: "+0.55" or "+7,556".

Any info. or advice is appreciated.

Thanks

 

[Jonmo1]

Welcome to the board...

Try the custom format

+0.00;-0.00;0

 

[mikerickson]

You could use the custom number format
+ #,###.00;- #,###.00;0

 

[Broker1]

Thanks for the quick responses: the problem with the custom option is it adds a blanket + to all numbers, even negative ones, so the that for negative numbers, they appear as follows: "-+955"...

 

[mikerickson]

My testing showed a - before negative numbers.

 

[Broker1]

For example, one cell appears as -960, but when I add "+0.00" to the custom list, the sample appears as "-+960.00"??

Is my Excel bugged, perhaps?? Unfortunately, I am not able to attach an image of this issue...

 

[Jonmo1]

For example, one cell appears as -960, but when I add "+0.00" to the custom list, the sample appears as "-+960.00"??

Is my Excel bugged, perhaps?? Unfortunately, I am not able to attach an image of this issue...

Don't select one of the built in custom formats...

You can create your own custom format by Selecting custom
Then put your cursor in the box and type in
+0.00;-0.00;0

Or
+ #,###.00;- #,###.00;0

Hope that helps.

 

[Broker1]

Yep, thanks Jonmo, that did the trick this time: I literally copied exactly what you wrote, with the semi-colon included, and I think that's what did it.

Thanks much.