Copy only what I see in a cell after formating

How do I copy and paste special so that what I paste is only the view from the copied cell? I am trying to do a mail merge with data from Excel and the merge pulls the number as 22.09635 instead of j...