Hi everyone,
I need to upload a lot of data and therefore the numbering needs to be in the following format:
18 digits, starting from 000000000000700000 + 1
To see the zero's I need to put a ' in front of the number and it won't increase by pulling it down (it gives met the number without zero's but that's not the purpose)
18digits.PNG
Does anyone can help me by formatting the cell in a particular way or giving me a formula so the zero's remain and my number is increasing?
Thanks.
____LD____
Maybe something like this formula, copied down:
Is that something you can work with?
Please Login or Register to view this content.
Couldn't you just do a custom format, Format Cells>Custom>000000000000000000
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:
Please Login or Register to view this content.
<---------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
Thanks, this works for me, without any difficult formula!!Originally Posted by ET1CARNES
Formatting is just a presentation and not the actual contents of the cell. Change the formatting and the contents may change in a manner that you don't want.
Use whatever works the best for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks