How do I change GLOBAL date format in excel?

=?Utf-8?B?MDRFYWdsZUYxNTA=?=

Guest

Posts: n/a

7th Sep 2007

When I run a query in MS Access and export the results to Excel the date
foramt is changed. I know how to change the formatting in the affected
columns but was wodering if there is a way to change this globally so I am
not forced to re-format several columns each time.

« Cell Absolute $ References Keep Changing themselves | automatically put in values from a price list »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
change date format to excel format	Motta	Microsoft Excel Programming	1	11th Mar 2010 09:21 AM
Change of date format when syncing Excel 2007 to Excel Mobilw	browniebodrum	Microsoft Excel Misc	8	29th Jun 2009 04:13 AM
date format will not change in Excel	Maxx	Microsoft Excel Misc	3	3rd Oct 2008 08:19 PM
How do I change date yyyymmdd to a Excel-supported date format?	dan	Microsoft Excel Worksheet Functions	3	6th Jul 2008 11:05 PM
Change satellite julian date format YYYYDDDHHMMSS to excel date ti	putley	Microsoft Excel Misc	1	11th Jan 2008 06:12 PM