how do I copy text with a plus sign at the front?

  • Thread starter Thread starter rich
  • Start date Start date
R

rich

I have text that I want into Excel that reads "+12/156" for example, and I
want to keep the plus sign at the front and I dont want it to compute the
fraction - it is not an equation, it is how the text is written. I want it
to remain "+12/156". I can't find a format...

thanks.
 
Format the cell as Text before you enter the text or precede the text with
an apostrophe (which will not show in the cell)
 
put an apostrophe or a space in front

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keeping the Plus Sign when importing from CSV file 1
Display plus sign 11
Plus sign in front of a formula 3
How do I make a plus sign show as text? 2
How do I display a "+" in front on positive numbers 3
Big white plus sign instead of normal arrow cursor? 1
Calculation by inserting = sign at the start of equaton 3
Copying rows depending on criteria set? 2

Back
Top