I HAVE THIS PROBLEM WITH MY PROJECT. I created a unique ID in excel with this code:but whenever 99,&999 comes the zero (0) is being deducted like the picture below. I'm wondering if what is the problem with my code

There is no problem with the formula. It is executing it correctly, but perhaps with the logic.Here's an alternative formula you may try:=TEXT(ROW()-1,"LU000000")

Forum Discussion

laj_16

Copper Contributor

Mar 02, 2023

Solved

GENERATED ID GETTING GETTING DEDUCTED

I HAVE THIS PROBLEM WITH MY PROJECT.

I created a unique ID in excel with this code:

but whenever 99,&999 comes the zero (0) is being deducted like the picture below.

I'm wondering if what is the problem with my code

excel

FikturFox
Mar 02, 2023
There is no problem with the formula. It is executing it correctly, but perhaps with the logic.
Here's an alternative formula you may try:
=TEXT(ROW()-1,"LU000000")

2 Replies

FikturFox
Brass Contributor
Mar 02, 2023
There is no problem with the formula. It is executing it correctly, but perhaps with the logic.
Here's an alternative formula you may try:
=TEXT(ROW()-1,"LU000000")
- laj_16
  Copper Contributor
  Mar 02, 2023
  thank you sir. I found also a new way which is almost the same as yours.
  
  ="LU"&TEXT(ROW(B1),"0000000")