Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Number stored as text
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 |
#2
|
|||
|
|||
Number stored as text
In either VBA or on the worksheet, once the values have been entered, place 1
in an un-used cell, copy it and paste/special with muliply checked over the cells you want to convert to numbers. -- Gary's Student "Andrew Clark" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |