Pasting Text Changes sheet font

[thescream80]

Hello,

Is there a way so that when I copy text from another source and paste it into excel it wont change the font. I know I can do paste special and then quick on text and it will be fine but is there a quicker way perhaps with a formula? I am using Calibri (Body) 12.

Any help would be greatly Appreciated.
[TABLE="width: 250"]
<colgroup><col style="mso-width-source:userset;mso-width-alt:10666;width:250pt" width="250"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 250"][/TD]
[/TR]
</tbody>[/TABLE]
<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri, sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { }.xl64 { }.xl65 { text-align: center; vertical-align: middle; }</style>

 

[6StringJazzer]

paste special and then quick on text

I don't know what you mean by this. You would Paste Special, Values.

And that is THE way to do it. If two clicks is too much then you can write a macro and bind it to your Quick Access Toolbar. That is what I do and here is the code I use:

Sub PasteValues()

   On Error GoTo NothingToPaste
   Selection.PasteSpecial Paste:=xlPasteValues, _
                          Operation:=xlNone, _
                          SkipBlanks:=False, _
                          Transpose:=False
   Exit Sub

NothingToPaste:
   MsgBox "Cannot paste copied values." & vbCrLf & Err.Description

End Sub