View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Turn off automatic date formatting

Format the cells as Text.
You can do this by doing a right click on a cell or an entire column. Then
choose fomat cells. In the Category choose Text

Should work

"jwt" wrote:

I'm pasting data into an Excel spreadsheet which is formatted as W-L-T, i.e.
1-0-2. Excel very handily insists that I'm trying to paste in a date, even
though most of the values clearly aren't valid dates (which values Excel
leaves alone). Other than writing a formula to figure out where Excel has
outsmarted itself, is there a way to turn this "feature" off?