issues with generating unique code in Excel -plz help

[Mitesh Satasiya]

Hi Chandoo,

As per attached spreadsheet, I am trying to generate a unique code in column X2 & X3, but as soon as drawing number changes from .4 to .5, it picks up the next number. How can I fix this issue.

Please note that I have all varieties of different drawings with ####.##.# to ####.###.### which I would like to convert to ####-###-### and hoping to have the formula covers them all.

Thank you very much.
Mitesh

 

[jindon]

Do you mean
TEXT(INT($V2), "000")
?

 

[Mitesh Satasiya]

Do you mean
TEXT(INT($V2), "000")
?

Hi jindon, Thank you for reply. yes, it is related to TEXT(INT($V2), "000") which is (probably due to rounding effect) generating FL46-041-813-05 instead of FL46-041-812-05...

I am trying to create a formula which can convert from range of ****-**-*.* to ****-***-***.** to ****-***-***-**. i.e. FL46-41-10.4 to FL46-041-010-04

 

[NARAYANK991]

Hi Mitesh ,

See if this thread is helpful :

http://chandoo.org/forum/threads/prevent-text-formula-from-rounding-off.30972/#post-184434

Narayan