Guna13
Board Regular
- Joined
- Nov 22, 2019
- Messages
- 70
- Office Version
- 365
- Platform
- Windows
Since I am only new to Visual Basic, I don't know much about programming. I have now manually processed this work.
In my Organization Fin Companies 001 to 999 Order, I download the Master dump file from the ERP system. Rather than showing all <100 Fin Companies, it shows only two digits instead of three digits
To update '002 or '083 or '088 in this format, I need to update ('xxx) this format manually. What is the best way to update this format via VBA. I have more than 3 laksh lines in my Master data dump at the moment
This Special format didn't work for my formula when I tried that General function.
Fin Comp
12
23
34
98
234
344
434
233
848
999
343
I need output should be
Fin Comp
'012
'023
'034
'098
234
344
434
233
848
999
343
In my Organization Fin Companies 001 to 999 Order, I download the Master dump file from the ERP system. Rather than showing all <100 Fin Companies, it shows only two digits instead of three digits
To update '002 or '083 or '088 in this format, I need to update ('xxx) this format manually. What is the best way to update this format via VBA. I have more than 3 laksh lines in my Master data dump at the moment
This Special format didn't work for my formula when I tried that General function.
Fin Comp
12
23
34
98
234
344
434
233
848
999
343
I need output should be
Fin Comp
'012
'023
'034
'098
234
344
434
233
848
999
343