Exporting time - no leading 0

F

Francois

Hi,

When I try to export a 24h clock short time field, I am in
trouble because of the following resulting formats:
"01-16-2004 10:32:20" and "01-16-2004 9:32:20"

What I would like to see is:
"01-16-2004 10:32:20" and "01-16-2004 09:32:20"

I have not found any way to get a leading zero for the
time when exporting. I also haven't found a way to
actually export the short time.

Any help?
Thanks,
Francois
 
J

Joe Fallon

Use a query and for each field you want to format use the Format function.
Then export the query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with time formats in Excel 2007, 0
Problem formatting dates from CSV file 2
Text field in report being converted to strange numbers in Excel 0
Lookup and count all cells that fall between 2 dates 3
import text file to Access database 2
Add Hours by Looping through Data Q 27
Avoiding Leads, using SVT, and Linking Tasks correctly 0
Macro Required.... 8

Top