Is it possible when using the Fill Down function (I assume its when you type a number in two cells and drag down to auto fill with more numbers) that the first one and two digit numbers will fill with a zero in front of them? How do you do this?
Example: instead of ...
1
2
3
it would be....
001
002
003
etc, etc.
You can apply a custom format to the cells of:
000
which will ensure that you will see 3 digits, with leading zeros where required.
Hope this helps.
Pete
you could just format that using the format cells....click on the column and right click and go to format....choose custom....in the custom box put 000.....yes, 3 zero's....HTH.....and welcome to the forum.....
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Just what I was looking for and the instructions on how to custom format was much needed. Thank you.
OK found another problem. I am using this to set up a Tab Delimited txt file for photo renaming program.
In the first column, I have my numbers 001 and on down. In the second column, I need the file name .dng next to the numbered column so I can do the formula =A1&B1 to merge the adjacent cells to read 001.dng, 002.dng, etc, etc. When I merge the data, I lose the zero in front. How do I keep from losing the zero's or is there and easier way to create what I am doing? I need to create list with about 500 numbers with file extensions down the column.
Example of the final result needed:
001.dng
002.dng
003.dng
Last edited by Photoray; 06-06-2013 at 11:43 PM.
have this in column next to numbers and fill down
if you want different file names in column B
Please Login or Register to view this content.
then
Please Login or Register to view this content.
Last edited by humdingaling; 06-06-2013 at 11:47 PM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
NICE! That worked perfectly.
There is more to Excel than I ever imagined. Thank you.
Or you could put this in your first cell (A1 ?):
Formula:
Please Login or Register to view this content.
then copy down.
Hope this helps.
Pete
Yes, that makes the work flow even faster. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks