Copying DNA from web and need to convert column date to ex: 11-15
I copy a DNA excel file from web but when I look at the excel spreadsheet I get a date in some columns example: Nov-15 and it should be a number example: 11-15. I have tried to convert the column and the cell but nothing works.
How can I convert the date to a number 11-15; I get a 5 digit number in the enter box. This is for any place in the columns which has two numbers separated with - as separator.

Tried the different copy/pastes; Keep source formatting and Match destination formatting. They both change the 11-15 to a date.

TIA,


Jack

Hi
have you tried formatting the cells as text before copying?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Yes Pecoflyer, that worked when I used match destination formatting.

Thanks,
Jack