formatting question

[maxx_daddy]

Hi all,
My software for work allows me to export a sheet as excel, but the numbers are not formatted as numbers. I am attempting to copy a cell with a price which has a "$" in front of it and paste it into a cell in my workbook that will auto sum. I have been successful in getting rid of the "$" using a MID formula and another destination cell. However the auto sum doesnt recognize the new cell and does not auto sum correctly. Thoughts of how I could paste a cell as a number? I'm a novice and this community has really helped a tremendous amount. Paste doesn't work in any fashion. The code is large, let me know what you would want to see and I will paste it here.

Thanks,

Joe.

 

[Robert Mika]

Hi maxx,
Beetwen two worksets you can try to Paste Special as Values.
To post data here:
You can download and install two of the following programs:

HTLMaker

or
Excel Jeanie


or when using Internet Explorer just put borders around your data in Excel and copy those cells into your post.

 

[maxx_daddy]

Here is what I'm using currently.

'total sale
Windows("a.xls").Activate
Range("AL34").Select
'[AL34].NumberFormat = "0.00" <-- didn't work
Selection.Copy
Windows("SDT2012.xlsm").Activate
Range("G14").Select
'g14 is new dest cell
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
Range("f14").Copy
'f14 has MID function and is formatted as currency
Range("g2").Select
'g2 is my desination cell, it is linked to a userform, in a perfect world i would just paste the data here (if I could format it correctly prior to pasting)
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
 
Application.Run "SDT2012.xlsm!Unshow" 'hides some sheets
Application.Run "SDT2012.xlsm!UF1S" 'shows the userform, i enter who bought it and who sold it and wallah