Excel - Copy Values

[CROY1985]

Hi all

I know we can paste values in excel, but is there any way to copy values?

I.e have some numbers formatted as 0.0k so 1200 would show as 1.2k, i want to copy the value of that cell (1200) into a google sheet, but what goes into google sheet is 1.2k as a text string.

In the above example if i drop the k, it does get imported as a number but only 1.2.....not the 1200.

Thanks

 

[gallen]

Only way I can think of is via VBA by adding the value of the cell to the clipboard

 

[gallen]

I have this code in sheets where I need to copy codes etc... It allows the user to double click a cell which automatically copies the contents to the clipboard.

If you have several sheets then you can place the CopyToClipboard sub in a Module then you just need the doubleclick event code in each sheet you want it to work on (or just once in the 'Workbook' object). Can be modified to only work with specific cells too.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    CopyToClipboard Target.Value
    Cancel = True
End Sub


Sub CopyToClipboard(Text As String)
    Dim MSForms_DataObject As Object
    Set MSForms_DataObject = CreateObject("new:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")
    MSForms_DataObject.SetText Text
    MSForms_DataObject.PutInClipboard
    Set MSForms_DataObject = Nothing
End Sub

 

[CROY1985]

Looks good, will give that a try next week (it's too late on friday afternoon to think!)

Thank you