Hi am trying to copy data into Excel. I am having trouble with the date
column, which should be in the format mm/yy. However, when I copy it in it
changes. For example 04/08 (meaning April 2008) will automatically change to
4-Aug. Itried changing the cell format to 'text', and I can enter data in ok
this way, but when I copy it in it goes back to the old 4-Aug. I am talking
about large quantities of data, so can not enter them all in manually. Can
someone help??