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

  • Thread starter Thread starter Anthony C
  • Start date Start date
A

Anthony C

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
 
Dim rng as Range
set rng = Intersect(Activesheet.UsedRange,Activesheet.Columns(5))
rng.Numberformat = "General"
rng.Value = rng.Value

integrate with your current code.
 
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

Number stored as text 4
number stored as text 1
Number Stored As Text 2
Number Stored as Text. 2
Number displayed as text difficulties 4
Excel Convert text to Number 9
Numbers stored as text 2
Fourier, numbers-as-text, and macros. 9

Back
Top