Thank you...your formula works perfectly...thank you!!

FLKulchar

--
Francis L. Kulchar
"ShaneDevenshire" wrote in
message ...
Hi,

Format the target range to TEXT first and then copy and in Excel see if
there are any Paste Special options available, if so pick formula or
values.

If that doesn't work you can format those cells to text and manually enter
the 1-3-1, if there arn't too many.

You could write code to make the conversion easier.

Or you could enter a formula like

=MONTH(A1)&"-"&DAY(A1)&"-"&RIGHT(YEAR(A1),1)


--
Thanks,
Shane Devenshire


"F. Lawrence Kulchar" wrote:

I am trying to copy a multicolumn table to my spreadsheet;

However, for about 5 of the fifteen columns, I get a "DATE",
such as

1-3-2000

instead of 1-3-1....which means the team won 1, lost 3, and tied 1.

If I reformat the " 1/3/2000 ", I get 36528 (i.e., the date's numerical
equivalent) -- i.e. still does NOT work.

Also, some columns have roughly half the numbers copied correctly, while
the
rest of the column is, again, an apparent "DATE".

Can anyone help please?

Thanks,

FLKulchar