Preventing auto date format

  • Thread starter Thread starter crapit
  • Start date Start date
C

crapit

When I copied a web content to spreadsheet, how to prevent excel from auto
convert the paste value to date format?
 
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
 
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
 
You must log in or register to reply here.

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
Date Formatting 3
How to Export Gmail Emails to PST Format? 4
Which is the best MBOX Converter Tool different formats conversion? 4
Auto fill not working 2
Prevent Copying and Pasting 2
Insert a row without taking formats from above (upper) rows or cells 6
Converting Spreadsheet into Executable 7

Back
Top