Forum home » Delegate support and help forum » Microsoft Access Training and help » RE: Dates
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
RE: Dates
Resolved · Low Priority · Version Standard
Reply Wed 5 Mar 2008, 15:12Delegate Mohammed said...
Mohammed has attended:
Access Intermediate course
Access Advanced course
Access VBA course
RE: Dates
Hi
I was wondering that how would you change an reversed date from a CSV file and convert it into a short date format,
for example
19991023 converting this into 23/10/1999
Help in this matter would be greatly appreciated.
Regards
Mo
For upcoming training course dates see: Pricing & availability
RE: Dates
Hi Mohammed, Thanks for the post, I dont really know how to approach this one in Access, however in Excel you could try the conversion with Paste Special. Select a blank cell, Choose Edit>Copy, Select the cells which contain the numbers; Choose Edit>Paste Special, Select Add, Click OK, To apply the number formatting choose Format>Cells, on the number tab, select the appropriate format then click OK. You could then import the table into Access. I hope that helps, best regards Pete.
|