Changing cell format

  • Thread starter Thread starter Brown
  • Start date Start date
B

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)?
 
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.
 
Hi
try the following code:

sub foo()
dim rng as range
set rng = activesheet.range("a1:A1000")
rng.value=rng.value
end sub
 
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
 
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
Click to expand...
 
Back
Top