I want to use a plus or an equal sign as text in a cell, not as a formula.
I want to use a plus or an equal sign as text in a cell, not as a formula.
Hi
Either format the cell as text before you enter it, or precede it with a '
Hope this helps, thruppence!
Andy.
"thruppence" <[email protected]> wrote in message
news:[email protected]...
>I want to use a plus or an equal sign as text in a cell, not as a formula.
Youu should just be able to type it but if you get a problem prefix with
single quote ' sign - this effextively formats as text
Sheila
"thruppence" wrote:
> I want to use a plus or an equal sign as text in a cell, not as a formula.
What if I imported a bunch of data with pluses in the text string and want to have it show as text?
I have tried LEFT(), CONCATENATE, & to try to insert a "'" in front of the text.
camacnei welcome to the forum but this thread is nearly 8 years old please start your own thread linking to this one if you think it may help
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks