| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add an equals sign to a cell that already has numbers in
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add an equals sign to a cell that already has numbers in
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add an equals sign to a cell that already has numbers
="="&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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add an equals sign to a cell that already has numbers
THANK YOU! YOU ARE AWESOME!
"David Biddulph" wrote: ="="&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! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add an equals sign to a cell that already has numbers
sorry but how do you do it for a whole bunch of cells? can't figure it out.
"David Biddulph" wrote: ="="&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! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add an equals sign to a cell that already has numbers
The same way.
-- David Biddulph "George" wrote in message ... sorry but how do you do it for a whole bunch of cells? can't figure it out. "David Biddulph" wrote: ="="&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! |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add an equals sign to a cell that already has numbers in
One method I tested.
Assuming data is in column A In B1 enter ="="&A1 and copy down. Now copy the range in column B and Paste specialvaluesokesc Now DataText to ColumnsNextNextColumn Data FormatFinish. Alternate..........use a UDF Function EvalCell(RefCell As String) Application.Volatile EvalCell = Evaluate(RefCell) End Function You have data like 234*45 or 1+56 =EvalCell(A1) Gord Dibben MS Excel MVP On Sat, 7 Mar 2009 10:02:01 -0800, 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! |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#10
|
|||
|
|||
Answer: How do I add an equals sign to a cell that already has numbers in
Adding an equals sign to cells in Excel
Note: Only select cells that do not already have an equals sign in them. Use the "Find what" field to search for cells with existing equals signs. Wrap any Excel formulas in Formula:
__________________
I am not human. I am an Excel Wizard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If a cell equals _, at the next row that equals _, return value fr | Excel Worksheet Functions | |||
| If cell is left blank, or equals zero, then cell equals a different cell | Excel Discussion (Misc queries) | |||
| Linking with equals sign doesn't always work | Excel Worksheet Functions | |||
| Can I change the Insert Function button to an equals sign? | Excel Discussion (Misc queries) | |||
| Eliminating Single Quote Before Equals Sign | Excel Worksheet Functions | |||
Hybrid Mode
