Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2005

Tip: Looking for answers? Try searching our database.

problem with date set up

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tim - 20 Dec 2005 11:11 GMT
Hi i download a merchant credit card transaction list. The credit card
expirery date is originally Month/year.

when it is imported it turns out as day/month/current year.

I can not convert this back, if I put in format month year, it just converts
the last 2 figures ie month /current year..

Any ideas       thanks Tim
Andy - 20 Dec 2005 11:18 GMT
Hi

Try using Data/Text to columns.
Select the column and click on Data / Text to columns. On the first two
dialog boxes, click next. On the third dialog option box, in the top right
corner, tell Excel that the column is a date and the format of that date.
Job done! Make sure you take a copy before you start.

Hope this helps.
Andy.

> Hi i download a merchant credit card transaction list. The credit card
> expirery date is originally Month/year.
[quoted text clipped - 5 lines]
>
> Any ideas       thanks Tim
Dave Peterson - 20 Dec 2005 14:51 GMT
I don't know how you download your data, but you may want to try this:

Save the download into a plain old text file (*.txt).

Then when you open that text file in excel, you'll be prompted to describe each
field.  You'll be able to choose Text for that field with the expiration date.
So excel won't change it to a date.

> Hi i download a merchant credit card transaction list. The credit card
> expirery date is originally Month/year.
[quoted text clipped - 5 lines]
>
> Any ideas       thanks Tim

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.