pavewayammo
Programmer
Ok here is my problem. I export a table from an Access database into an Excel spreadsheet then in to another Access database. I know it sounds stupid but I can't just link the two Access databases or make any changes to the orginal Access table exporting from.
On export, the time is in 24hr format but on the spreadsheet it removes all the 0's infront of other numbers. For example 0800 comes out as 800 or 0000 come out as 0.
Now I would like to put this back in the the 4 digit 24hr format but to this point I have been able to figure it out. I have tried messing around with the format on the Access table also.
I would go as far as making a macro for the Excel spreadsheet to correct it.
paveway![[machinegun]](/data/assets/smilies/machinegun.gif "[machinegun] [machinegun]")
Looking for help check the FAQ's first then do a search then ask. Worked for me.
On export, the time is in 24hr format but on the spreadsheet it removes all the 0's infront of other numbers. For example 0800 comes out as 800 or 0000 come out as 0.
Now I would like to put this back in the the 4 digit 24hr format but to this point I have been able to figure it out. I have tried messing around with the format on the Access table also.
I would go as far as making a macro for the Excel spreadsheet to correct it.
paveway
Looking for help check the FAQ's first then do a search then ask. Worked for me.