Preventing auto date format

C

crapit

When I copied a web content to spreadsheet, how to prevent excel from auto
convert the paste value to date format?
 
S

Sebation

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

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
 
Top