format

G

galin

Hi, guys.

I am trying to format a field in my table. I have Time_Punch_in whic
is in format 900000. I'd like to convert it to be 09:00 or 9:00.

I had the same problem in Excel. I used a formula which was provide
for me to convert 90000 to 9:00. However, when I imported the Exce
fiel to Access I 've lost my formatted field.

Do you have any ideas how to fix this problem?

Thank you

Gali
 
M

Marin Kostov

Just use the same format from Excel to Access.
The formatting changes ONLY the way the data is displayed, not the actual
data.
 

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

Problem formatting dates from CSV file 2
Date format automatically changed 1
2007 conditional formatting not playing ball 5
Time - Time formatting 3
Peculiar default cell format 1
Date/Time 1
synchronize combo box problem 2
problem with combo box synch 4

Top