+ symbol

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tat - 04 Sep 2005 15:39 GMT

I want to add the "+" symbol to text but when I type it and enter, I
lose the "+" symbol.

Example: +12 becomes just 12, I want to show the "+" symbol, any
ideas?

Signature

tat

Reply to this Message

duane - 04 Sep 2005 15:41 GMT

enter as '+12

note that this will be text and not a number so you can't use it i
addition etc without some more wor

--
duan

Reply to this Message

Chip Pearson - 04 Sep 2005 19:41 GMT

> note that this will be text and not a number so you can't use
> it in
> addition etc without some more work

Actually, Excel will convert the string to a number, so it can be
used in calculations.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

> enter as '+12
>
> note that this will be text and not a number so you can't use
> it in
> addition etc without some more work

Reply to this Message

BenjieLop - 04 Sep 2005 15:43 GMT

tat Wrote:

> I want to add the "+" symbol to text but when I type it and enter, I
> lose the "+" symbol.
>
> Example: +12 becomes just 12, I want to show the "+" symbol, any
> ideas?

You can do it by:

1. formatting your cell to TEXT before making cell entries

OR

2. preceding your entry with an apostrophe. i.e., '+12

Regards.

Signature

BenjieLop

Reply to this Message

tat - 04 Sep 2005 15:46 GMT

Thanks guys, works great, just what I needed. :)

Signature

tat

Reply to this Message