Hi Abdul,
I think we don't need to use the below code due to which it changes those
cells since a non-numeric found and as soon as a non-numeric cell encounters
it exit the macro due the following lines of code.
Else
Exit Sub
End If
Bakul,
Try the below code:
Sub
Hi Bakul,
You'll have to include the formatting lines in the code I sent in order to
insert an = in front of numbers and into blank cells.
Regards - Dave.
Date: Fri, 14 Aug 2009 15:02:13 -0700
From: bakulpatel...@yahoo.com
Subject: $$Excel-Macros$$ Re: insert = in every cell as prefix with nos
Hi Bakul
Try this one
Sub Insertequals()
Dim cel As Range
For Each cel In Selection
If IsNumeric(cel.Value) Then
cel.Value = = cel.Value
Else
Exit Sub
End If
Next
End Sub
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf
This code just a refined shape of Dave code for multi cell selection, just
put the code in any vba module select your desired range where you want to
put = sign and press Alt+F8 run insert equal macro.
Sub InsertEquals()
Dim cel As Range
With Selection
For Each cel In Selection
HI Abdul,
Is it possible to insert '=' as prefix with nos only.
If yes, give me code.
Thanks,
Bakul
--- On Fri, 8/14/09, Abdul Shakeel shakeel@gmail.com wrote:
From: Abdul Shakeel shakeel@gmail.com
Subject: $$Excel-Macros$$ Re: insert = in every cell as prefix with nos Blank
To:
suppose i have list and want to insert X' or ='' before each no., is there
any way to insert the item(x,=) as prefix by using find Replace method or any
other method
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Manoj
Hi,
I think you'll have to use VBA.
Have a look at the attachment. Select the cell you want to change, then press
Ctrl+q
However. the cell is then treated as text, and cannot be used in calculations.
Is this what you need?
Regards - Dave.
From: manoj...@ocimumbio.com
To:
