Turning off auto date formatting

  • Thread starter Thread starter TJ
  • Start date Start date
T

TJ

How can I turn off the auto date formatting function in
Excel? I'm dragging data in from another application and
Excel is converting some of the data (i.e. 01-05) into
dates. I can't modify the cell formats before pasting
because the other application launches a new file as part
of the paste operation (which uses the default cell
formats). Therefore, I need to turn off the auto date
format feature so it will be off when a new file is opened.

Thanks for the help!
 
TJ

Harland Grove posted about this last week and I'm afraid
that you can't turn the option off.

You will have to insert a space (or a apostrophe) before
the original data so that "01-05" becomes " 01-05"
or "'01-05"

Another option maybe to create a template with appropriate
columns formatted as text and get the other application to
use this template.

Regards
Peter Atherton
 
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

1-4-1 is not a date how do I stop excel from changing whats enter 4
Problem formatting dates from CSV file 2
Custom auto filter (Dates) 2
Peculiar default cell format 1
Date pasted web site causing inconsistent date format 2
auto format 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
data changes to date format 1

Back
Top