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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prevent auto date format 3
Auto fill not working 2
date format convert 2
convert to date format 3
The next Grand Theft Auto title has been officially announced 0
MS Access problem 0
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
date format not change in custom 2

Top