LinkBack URL
About LinkBacks
If you start off with the 18 digit number formatted as text without using the ' , that you want as a starter in A1 and want to increment this number by 1 as you go down column A this will work.
Formula:
=LEFT(A1,17)&ROW()-1
If you start off with the 18 digit number formatted as text without using the ' , that you want as a starter in A1 and want to increment this number by 1 as you go down column A this will work.
Formula:=LEFT(A1,17)&ROW()-1
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks