[ExcelVBA] A loop to insert leading zero(s) as string

 

I want to use a loop to evaluate cells that are formatted as string (this is same as text right? or NumberAsText).
If the string in the cell is 10 characters long nothing will happen.
If the string in the cell is less than 10 characters I want VBA to insert the approriate number of "zeroes" to make up the difference thus having a string that now equals 10 characters.

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___