Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I copy text with a plus sign at the front?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I copy text with a plus sign at the front?
Format the cell as Text before you enter the text or precede the text with
an apostrophe (which will not show in the cell) -- Kind regards, Niek Otten Microsoft MVP - Excel "rich" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I copy text with a plus sign at the front?
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 "rich" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to display $ sign in front of: 50 under, 50 over | Excel Discussion (Misc queries) | |||
How do you make a plus sign appear in front of a number? | Excel Discussion (Misc queries) | |||
equal sign in front of date in formual bar | Excel Worksheet Functions | |||
Plus sign in front of a formula | Excel Discussion (Misc queries) | |||
How do I show a multiplication sign in front of a number | Excel Discussion (Misc queries) |