software

I have recorded a Macro which will edit a cell from text to numeric. The
problem I have is that the Macro will only do one cell at a time. I am
working on a huge database and the file I am working with has an apostrophe
at the beginning and ending of the values I need to convert.

I need a quick response as I am under a tight deadline.

Hello,

Can you post your macro?

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAMquot;ExcelNovicequot; gt; wrote in message
...
gt;I have recorded a Macro which will edit a cell from text to numeric. The
gt; problem I have is that the Macro will only do one cell at a time. I am
gt; working on a huge database and the file I am working with has an
gt; apostrophe
gt; at the beginning and ending of the values I need to convert.
gt;
gt; I need a quick response as I am under a tight deadline.
As always, post your efforts for assistance

--
Don Guillett
SalesAid Software

quot;ExcelNovicequot; gt; wrote in message
...
gt;I have recorded a Macro which will edit a cell from text to numeric. The
gt; problem I have is that the Macro will only do one cell at a time. I am
gt; working on a huge database and the file I am working with has an
gt; apostrophe
gt; at the beginning and ending of the values I need to convert.
gt;
gt; I need a quick response as I am under a tight deadline.
There are different ways to do loops, it would be easier to make a suggestion
if we knew what your macro looked like thus far.

But, there may be an easier way to remove those apostrophes than using a
macro.

Highlight your range of data, then do a Find/Replace. Replace ' with blank.
That will eliminate the end apostrophe from all of your data.

Then, in any blank, unused cell, enter the number 1. Then copy this cell.
Highlight your range of data, then select quot;Paste Specialquot;. Select quot;Multiplyquot;
from the Paste Special window, then click OK. All of your data will now be
multiplied by 1, which will convert it to a number, without changing the
value.

HTH,
Elkarquot;ExcelNovicequot; wrote:

gt; I have recorded a Macro which will edit a cell from text to numeric. The
gt; problem I have is that the Macro will only do one cell at a time. I am
gt; working on a huge database and the file I am working with has an apostrophe
gt; at the beginning and ending of the values I need to convert.
gt;
gt; I need a quick response as I am under a tight deadline.