format

  • Thread starter Thread starter galin
  • Start date Start date
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
 
Just use the same format from Excel to Access.
The formatting changes ONLY the way the data is displayed, not the actual
data.
 
You must log in or register to reply here.

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

Time - Time formatting 3
Date format automatically changed 1
Problem formatting dates from CSV file 2
Excel Convert Datetime Stamp to HH and MM Worked 7
Sorting by time starting from a specified time. 4
Pivot table macro filter data between yesterday and today (date+time) 0
Peculiar default cell format 1
single cell time entry as time - time; Ever seen this? 12

Back
Top