Column listed as "Number Stored as Text" - Exported from Access
 

Hi All,

I have an Access automation routine that's kicking out the results in Excel.
Currently, everything seems to be working well, except one column that ends
up with the "Number stored as text" issue when all values end up as 0.

Does anybody know how to fix this -in the automation-? There are a
significant number of spreadsheets generated by this app, and it would be
too time-consuming to go through each one and manually select the cells &
change to number.

Thank you!
-Anthony

Column listed as "Number Stored as Text" - Exported from Access
 

Dim rng as Range
set rng = Intersect(Activesheet.UsedRange,Activesheet.Column s(5))
rng.Numberformat = "General"
rng.Value = rng.Value

integrate with your current code.

--
Regards,
Tom Ogilvy


"Anthony C" wrote in message
...
Hi All,

I have an Access automation routine that's kicking out the results in
Excel.
Currently, everything seems to be working well, except one column that
ends
up with the "Number stored as text" issue when all values end up as 0.

Does anybody know how to fix this -in the automation-? There are a
significant number of spreadsheets generated by this app, and it would be
too time-consuming to go through each one and manually select the cells &
change to number.

Thank you!
-Anthony