(xxx).Value = (yyy).Value is Copying Number/Currency as Text? Need Number!

Hi Guys,

First time I've come across this and I can't figure out how else to do it.

Rather than Copy/Paste, I use (e.g.) - Range("A1").Value = Range("A2").Value - to copy values across (usually from one workbook to another).

However, I have some Currency figures (and dates incidentally) that are copying across with an error as they are 'numbers stored as text'.

I have formatted all the relevant cells so they are Currency, but when this copies across, it still copies as Text. So do the dates.

I've also tried .Value2 (something new I learned today!) but it's still text.

Anyone tell me why this is going wrong?!?!?

Thanks,
ExcelNat

Thanks for replying :-)

Hmmmm I've not used CCur before...

How would I use it?

E.g. my code would look like:

Please Login or Register  to view this content.

Where all columns contain text except the 3rd column which is a date and 6th column which is currency??