| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasted values that paste as "number stored as text" | Excel Discussion (Misc queries) | |||
| Text stored in a cell is displayed as a string of "#####..." | Excel Discussion (Misc queries) | |||
| Can Excel "extract" ranges of numbers listed in the A column? | Excel Discussion (Misc queries) | |||
| How do I ignore the "Number stored as text" error message permane. | Excel Discussion (Misc queries) | |||
| unable to get original cell value from a "number stored as text" | Excel Programming | |||
Linear Mode
