Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting Numbers Imports
I import a Cost Code which is structured as such : - ##-##-## (with an
existing unecessary leading hyphen but that is the way it is) Unforturnately, MID(ActiveCell,4,8) for 09-04-50 returns a date formatted as 9/4/1950 instead of the desired format as 09-04-50. I tried to format the column as TEXT before the import, or MID with TEXT() in my code without being able to fix the problem. The solution is probably simple but I don't have it. Help appreciated. Celeste |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XML Web Imports | Excel Programming | |||
Which imports for stdole in vb.net | Excel Programming | |||
Refreshing Imports | Excel Programming | |||
ODBC imports numbers as text | Excel Programming | |||
Imports | Excel Programming |