Hi
I have in column C a list of numbers ranging from 100 to 2000, for all 3 digit numbers i want them to be displayed as 0100 (with a 0 added at the beginning)
as the format is important for other macros to work well.. Any help is appreciated thanks!
Also, the macro has to be run over an entire folder,i currently have this code that converts csv files to xls, if you can add to this code to take care of number conversion , that would be great.
Please Login or Register to view this content.
Also, in the above code, i get csv to xls conversion but i have both files in my folder, is there a way to delte the original csv files?
To "Format" a column with a 4 digit display is pretty easy, it's the kind of thing you could turn on the macro recorder and record yourself doing that manually, then slip the code snippet you pull from the recorded macro into your other macros(s) as needed.
The KILL command can be used to delete a file, since you already have the path and filename, you're almost there.
See if you can work those two things out from these two hints. Post back with what you're tried if what you come up with doesn't work.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
i got this:
and it works :D thanks!!Please Login or Register to view this content.
but when i proceed to next step of my task copying the cell value to be used somewhere else,again copies the 3 digit number...can w e convert this to text
You said you wanted to FORMAT the column C to display 4 digits, which I'm sure your highlighted code actually does. But it's just a display trick, the value in the cell is still 3 digits.
You can perform the same "trick" on the fly in your other code to take the value in the cell and "format" it as you use it elsewhere. For instance, using a single sample value in C2:
Please Login or Register to view this content.
I tried something like this:
Still having same issue..can u correct me if somethings wrongPlease Login or Register to view this content.
After you have converted the column C itself to text, I'm thinking the code above would work.
Please Login or Register to view this content.
Great this works..but once i do this @ conversion , the 0000 formatting is lost in the original sheer
That is correct. But your macro will be able to do what it needs to do.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks