Subtotal Problem

[Thomas P. Peacock]

I have imported data from a golf software program listing three rounds of
golf for individuals. I want to subtotal their scores based upon a team
within the tournament. When I try the subtotal command Excel separates the
team members but returns "0" for the subtotal. I was told that Excel does
not recognize the content of the cells and I must multiply their value by
"1" and do a special paste command . . . I forgot how to do that. Also, is
this a problem with the golf software, data transfer, or something else?
Thanks, Tom

 

[Debra Dalgleish]

I don't know about golf software, but when I copy from Access 2002 and
paste into Excel, the numbers are pasted in as text. Instead of pasting,
you can choose Edit>Paste Special, and choose csv or Text.

Or, do a normal paste, and then change the data back to numbers:

1. Select an empty cell on the worksheet
2. Choose Edit>Copy
3. Select the cells that you pasted from the golf software
4. Choose Edit>Paste Special
5. Select Add, click OK

If you do this frequently, you can use a macro to convert the numbers.
I use this one (written by Jon Peltier):

Sub ConvertToNumbers()
Cells(65535, 255).Copy
Selection.PasteSpecial Paste:=xlPasteValues, _
Operation:=xlPasteSpecialOperationAdd
End Sub