Thread: Formula Help Request
View Single Post
 
Old 12-16-2013, 01:57 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,362
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote