Formula to keep leading zeros in excel 2016 with variable number lengths,
- or -
Post a project like this2785
$25
- Posted:
- Proposals: 8
- Remote
- #1257252
- Awarded
Data scraping / data mining / data extraction / web scraping / scraping / data conversion / General admin support and more
Kent
WordPress DataEntry | uploading | Web Admin | Photoshop | Data Entry | PDF2Word | Virtual Assistant | Ad-posting
Zongzhai
38541113905825588127026973050583749110096811237383
Description
Experience Level: Expert
Formula to keep leading zeros in Excel 2016 with variable number lengths, then to keep the 0 when converting to .csv file. Column 1 are account numbers and column 2 is fixed 9 digit routing numbers. Must be able to convert/export to .csv file to work for me!
One column has variable lengths numbers and the second is a fixed 9 digit numbers. This has rolls of 250 to 300
Column C (see attached) - variable length #
Column D (see attached) - fixed length #
One column has variable lengths numbers and the second is a fixed 9 digit numbers. This has rolls of 250 to 300
Column C (see attached) - variable length #
Column D (see attached) - fixed length #
Walt L.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
31 Aug 2016
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Walt,
Will it work for you, if I develop a C program for it ?
Thanks
Sumit
SaS TechnologiesWalt L.21 Aug 2016I don't know what a C program is. what would it do for me?
115112
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