Excel Autoformating cells

  • Thread starter Thread starter Piglet
  • Start date Start date
P

Piglet

Is it possible to stop excel from Auto formatting a cell into date fprmat
when you paste date in from the internet?
 
You could try Paste Special>Text

Or copy into Notepad, save then open with Excel to get the Text to Column Wizard
where in Step 3 you choose Text as Column Data Format.


Gord Dibben MS Excel MVP
 
Hi Gorb,

Thanks for the response - we've tried to paste special as text but it
still autoformats the cells into a Date format. The text to columns way does
work as we've tried this, but we were wondering if there is a quicker way of
doing it as this is quite a laborous process when you are having to do this
20 times?

Best Regards

Piglet
 
Can you use Data>Import External Data>New Web Query?

In your query you can specify in Options to "disable date recognition"


Gord
 
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

Adding days to a date - changed in Excel 2010 8
Date pasted web site causing inconsistent date format 2
Excel Data pastes into 2 cells not 1 1
Excel Average dates help 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Stop automatic formatting of cells (number, text, date, etc) 4
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Custom auto filter (Dates) 2

Back
Top