="="&A1 in a helper column, then copy and Edit/ Paste Special/ Values, then
Edit/ Replace = by = to change from text to a formula.
--
David Biddulph

"George" wrote in message
...
the problem is there is no function. it basically has a bunch of numbers.
6*12.99, or 4*2.99 etc. and it keeps going. i just need to add = sign in
each cell and not lose the rest.

"francis" wrote:


I can think of the Replace function but you need to shows some
examples of how your functions look like.

--
Hope this is helpful

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


Thank You

cheers, francis










"George" wrote:

I have hundreds of cells that already have some sort of function in
them but
do not know how to add the equals (=) sign to each cell automatically
instead
of going through each cell individually which will take forever.
Please
help. Thank You!