VBA CODE to show leading zeros
- or -
Post a project like this2174
£44(approx. $55)
- Posted:
- Proposals: 21
- Remote
- #1987566
- Awarded
AUTOMATION EXPERT l VBA l PYTHON l SQL l POWER AUTOMATE l WINAUTO l DATA ANALYSIS l ACCESS
Greater Noida
Excel expert VBA, Wordpress website, Virtual Assistant, Data Entry, PDF, Transcriber, HTML
Ulhasnagar
35495486495270269753939649865153654717684031541911228050130661113718271449473
Description
Experience Level: Expert
We require a VBA code to:
Add a leading zero to a fixed length string amongst variable length strings.
E.G. 123456789 to become 0123456789 - it is to look for 9 digit numbers and add the leading zero to those only.
if the code encounters 123456 it is to remain unchanged and if it encounters ABC12345 again it is to remain unchanged. If there are shorter numbers and if there are shorter letters and numbers it is to ignore those.
Add a leading zero to a fixed length string amongst variable length strings.
E.G. 123456789 to become 0123456789 - it is to look for 9 digit numbers and add the leading zero to those only.
if the code encounters 123456 it is to remain unchanged and if it encounters ABC12345 again it is to remain unchanged. If there are shorter numbers and if there are shorter letters and numbers it is to ignore those.
Burton Motor Factors B.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
26 Apr 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies