English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

how do u put + signs in microsort excel

2006-09-28 00:38:46 · 8 answers · asked by sparkynicci 3 in Computers & Internet Software

8 answers

put an single quote in front

'+

its the same for any mathematical operators. the single quote wont show in the cell, and also decalres anything after it as a string (text).

You could format cells, but you may need to add the + to a different cell (currency cell)



jamie

2006-09-28 00:41:19 · answer #1 · answered by Anonymous · 1 0

Did you try the + it should work or are you looking like a plus to profit or something?

Then go to Format > Cells and there should be an option to put a + sign in there.

2006-09-28 07:41:20 · answer #2 · answered by Michael 2 · 0 0

www.mrexcel.com/ They can answer any question you can possibly imagine about excel and tell you 3 or 4 different ways to do it.

2006-09-28 07:42:47 · answer #3 · answered by Movie Guy 3 · 0 0

Format the cell to accept text only.

2006-09-28 07:41:41 · answer #4 · answered by Letsee 4 · 0 0

Just press plus button

2006-09-28 07:48:18 · answer #5 · answered by Anonymous · 0 0

+

2006-09-28 07:40:40 · answer #6 · answered by chimp 2 · 0 0

shift +

2006-09-28 07:47:18 · answer #7 · answered by ? 4 · 0 0

you use the + key for that

2006-09-28 07:43:33 · answer #8 · answered by ghreewala 4 · 0 0

fedest.com, questions and answers