Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Text Formated Numbers into Numbers all in VBA
Hi -
I have a set of data that is coming out of an ERP system - and in many cases, it changes the numbers in text. I have a routine that works by writing the value "1" to a cell in the worksheet, then multiplies the entire range of data by 1 using: Selection.PasteSpecial Paste:=xlValues, Operation:=xlMultiply, SkipBlanks _ :=False, Transpose:=False Is there a way of doing this all in VBA w/o setting a cell to the value of 1? I'd like to take a range selection multiple it by 1 and put it in the same place on a worksheet from which it came before being multiplied. Thanks Marston |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Text Formated Numbers into Numbers all in VBA
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Text Formated Numbers into Numbers all in VBA
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text formated cells with numbers | New Users to Excel | |||
Formula for extracting text formated numbers within ( )'s as numbe | Excel Discussion (Misc queries) | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) |