Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date mm/yy
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date mm/yy
HI,
This is happening because excel is by default set to recognize the date format as US English. You can go to format select date from the number tab and in the drop down list (local location) select English (United Kingdom) and excel with recognize your date format. Hope this helps you. -- Thanks Suleman Peerzade "naomi" wrote: 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?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date mm/yy
Think part of the problem you face lies also in the ambiguity in the "date"
data that you're pasting. It doesn't have the day part. Try it in this sequence 1. Pre-format the entire col A (say) as TEXT 2. Do a "Paste special" as values of the data that you've copied into col A 3. Put in B1: ="01/"&A1 (this is to attach a "day" part to the pasted strings, eg: "04/08") Copy B1 down, then freeze col B with an "in-place" copy n paste special as values 4. Select col B, click Data Text to Columns. Click NextNext. In step3 of the wiz., check "Date", select: DMY from the droplist. Click Finish. Then just apply a custom format of: mmmm yyyy to get the desired results in col B. -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "naomi" wrote: 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. I tried 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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |