Changing cell format

[Brown]

I have a worksheet that is populated with data exported from Access.
The data in the Access table was serial numbers with an occasional (rare)
alpha character.
The column was formatted "Text" in Access. When I exported it to Excel,
every value in this field (around 3000 entries), has an apostrophe (')
inserted at the frontof the cell. Find and Replace does not see the '
How can I remove this so that I can use Fill>Series to populate the gaps in
my data (there are many gaps)?

 

[Richard O. Neville]

Try copying the ' Access character and pasting it into the Replace menu. It
could be that the character was not originally inserted using the '' ' key.

 

[Frank Kabel]

Hi
try the following code:

sub foo()
dim rng as range
set rng = activesheet.range("a1:A1000")
rng.value=rng.value
end sub

 

[Brown]

Great! It workedlike a charm --
Now what did it actually do?
I don't see what it did unless by setting the rng.value to rng.value it
redefined the cells as numbers.

Brown

 

[Myrna Larson]

It did the equivalent of retyping each entry.

Great! It workedlike a charm --
Now what did it actually do?
I don't see what it did unless by setting the rng.value to rng.value it
redefined the cells as numbers.

Brown

 

[Brown]

TNX, I'm alittle smarter now !
Brown

It did the equivalent of retyping each entry.