ramyadixit99
New Member
- Joined
- Jan 2, 2015
- Messages
- 9
Hi,
I have a sheet which has =========== in some of the cells.
Macro i need to write should do the following
Check each cell in the sheet
If it begins with =, it needs to add an ' (apostrophe) at the beginning.
So that excel doesnt treat the = as a formula.
Regards,
Ramya
I have a sheet which has =========== in some of the cells.
Macro i need to write should do the following
Check each cell in the sheet
If it begins with =, it needs to add an ' (apostrophe) at the beginning.
So that excel doesnt treat the = as a formula.
Regards,
Ramya