Copy column containing mixed data 1

[rogerte]

I am copying data from one workbook to another workbook, and basically it works fine.

The only problem is that is if one column consists of data that that could be a number, but is actually text it is saved in the new column as a number.

e.g. donor column contains: 4.w, 5.15m, 7f, 09.00, 6m. The recipient column will contain 4.w, 5.15m, 7f, 9, 6m

I am using:

ThisWorkBook.Sheets(2).Range("C" & i & ":C" & k) = ImportFile.Sheets(1).Range("C2:C" & j).Value

I have tried searching for a solution - but so far Google hasn't been my friend - possibly me not using the correct search text.
Is there an easy way to keep the format?

Many thanks

Roger

 

[SkipVought]

hi,

If you select the cell that displays 09.00, and look at the FORMULA BAR, rather than the CELL, what do you see in the FORMULA BAR?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

I'd try this:

ImportFile.Sheets(1).Range("C2:C" & j).Copy ThisWorkBook.Sheets(2).Range("C" & i)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[rogerte]

PHV,

Thanks - that worked a treat

Cheers

Roger