View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
George George is offline
external usenet poster
 
Posts: 347
Default How do I add an equals sign to a cell that already has numbers

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!