Thread: How do I add an equals sign to a cell that already has numbers in
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lori Lori is offline
external usenet poster
  
Posts: 272
Default How do I add an equals sign to a cell that already has numbers in
OR... Under ToolsOptionsTransition select "Transition Formula Entry"
then select the whole column and choose DataText to ColumnsFinish.
(Uncheck this option after)



"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!
Reply With QuoteReply With Quote