PDA

View Full Version : in Excel, how to show a '+' in front of a value?



Oggy
10-09-2007, 08:27 AM
Our board has asked my boss to produce a spreadsheet that shows negative values with a minus sign in front which is easy enough but they also want to have positive values shown with a plus sign in front. I reckon it'll just make it harder to read but hey ... they are the Board and are not to be trifled with.

I've never seen this done anywhere so can someone tell me if there's a standard format that will achieve this?

I can think of a workaround using another column and an 'IF' formula but that'll be a bit messy too.

Presently the boss is just taking the value and converting it to a label by putting a comma and then a '+' sign in front of the value which is a bit labour intensive.

RogerRamjet
10-09-2007, 09:29 AM
Hi Oggy

Under Format/Cells/Number Tab/Custom, enter +##0.00;-#,##0.00

Cheers.

Roger

Oggy
10-09-2007, 09:50 AM
Thanks for that RR.
My boss now has a big smile on her face

Cheers