Reformatting Issue

B

bkube01

I use an Access Query to an Oracle database to pull fields like date
and hours. I copy the sheet from Access and paste it into Excel.
end up with a bunch of cells containing hours data with that littl
green triangle in the upper left corner of the cells. I format th
columns to number with 1 decimal, but green triangle remains. The onl
way I have found to convert this data is to do an F2/Enter on each cell
I have too much data to continue this way. I have the same issue wit
the date columns. Any ideas??? Thanks.

Bria
 
C

crispbd

Do the triangles bother you? You can format the fields in the quer
itself if you prefer
 
M

mroby

Since you are using MSAccess to pull the data, you could create a table in
Access that has the formats built in, then append your query to the table,
and finally export that table to Excel. This will give you more fixed
formatting.

Hope this helps.
 
Top