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

Paragraph numbering in Word 1
How can the font and size of (all) citation numbers be altered? 1
Date Formatting 5
Auto match destination formatting for Mac 0
Date Formats 4
Excel does not accept text format! 0
Paste to excel from word - auto format problem 1
Prevent auto date format 3

Top