Excel 2000 Importing data from Access DB

Status
Not open for further replies.

Michelle2

Posts: 35   +0
Hello everyone.

When I import data from an Access DB into excel format, the numbers field doesnt work so I cant for instance do a sum for total number of hours spent on a job.

I can use the tick on seperate cells which enters the data to number, but this would take far too long. I have also tried to right click on the collum header and format cells to numbers but this also doesnt work.

So my question is this. Is there an easy way to reformat the cell data to number, or for excel to do this automatically on import?

Thank you
 
Status
Not open for further replies.