Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
I have a little VBA app that pulls data from a database. All data is brought in correctly, but one column will not format as number, and when I save the resulting workbook, I get all those "Number stored as text" smart tags. I can't figure out what to put here ("General" doesn't seem to work here): Columns("D:D").NumberFormat = ? to store those numbers as numbers and not text. MSDN has been most unhelpful. Any suggestions? Thanks, Andrew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Paste a number as text | Excel Discussion (Misc queries) | |||
PREVENT conversion of text to number? | Excel Discussion (Misc queries) | |||
Format Number to Text | Excel Worksheet Functions | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
returning a text cell based on a number cell | Excel Worksheet Functions |