Hi Tony,

The paste issue really has nothing to do with the Function and it's not something the Function could be made to do a reasonable interpretation of (I gather you're hoping for something that can work out that the commas aren't thousands separators but are just commas in a string of numbers). That aspect might be better handled via one of the PasteSpecial options. Even re-applying the General format isn't going to restore the commas to the data, though.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]