C crapit Sep 16, 2007 #1 When I copied a web content to spreadsheet, how to prevent excel from auto convert the paste value to date format?
When I copied a web content to spreadsheet, how to prevent excel from auto convert the paste value to date format?
S Sebation Sep 16, 2007 #2 as i know,excel can not auto adjust the copy content to the define format,while u can use vba to attain the goal. i.e. Private Sub Worksheet_Change(ByVal Target As Range) With Target .Font.Name = "courier new" .Interior.ColorIndex = 24 End With HTH Regards Sebation.G
as i know,excel can not auto adjust the copy content to the define format,while u can use vba to attain the goal. i.e. Private Sub Worksheet_Change(ByVal Target As Range) With Target .Font.Name = "courier new" .Interior.ColorIndex = 24 End With HTH Regards Sebation.G
G Gord Dibben Sep 16, 2007 #3 Can you bring the content in using a Web Query through Data>Import External Data? Through that method you have the option in the query dialog to turn off "date recognition". Gord Dibben MS Excel MVP
Can you bring the content in using a Web Query through Data>Import External Data? Through that method you have the option in the query dialog to turn off "date recognition". Gord Dibben MS Excel MVP
