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
|