What you're doing is fine--if you have a small quantity of values that need to
be fixed. But if you had 64k or 1mb of data that needed to be fixed, you may
want to do it a different way.

James Silverton wrote:

David wrote on Wed, 7 Mar 2007 12:37:41 -0000:

DB The apostrophe will set the contents of the cell to text.
DB If you want to convert it to a number, try using paste
DB special to add zero or multiply by 1.
DB --
DB David Biddulph

DB "Syndrome" wrote in
DB message
...

?? I want to match data from the other sheet where the cell
?? entry is - 123456 and is like this in both cell and
?? formula bar.
??
?? I have six hundred rows of data to match using an IF
?? formula but as the the data in the formula bar is

?? Hope you can help.

Can you tell me if I am doing something wrong with this problem?
I am using Office 2002 and, if I select the column of cells with
text representations, I get the signal "number stored as text"
and clicking "convert to number" seems to be make the necessary
change. This works even if some of the cells are really numbers.
I have had similar problems to the OP with inherited data or
that entered by others.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

--

Dave Peterson