Related Posts

4 comments

Kanwaljit`

Hi Bastien,

May the couple Live 1000 years !

Nice to see the new version . I have just dipped my fingers….
Yummmmmmmmmy….. BTW have you got the file, I sent you… I have sent it thrice.

Warm Regards
Kanwaljit

    Bastien

    Hello Kanwaljit,

    Unfortunately I still haven't received your email.
    I'm not sure how big it is or what the file name is, but perhaps it is lost
    somewhere in the process. You might try to send me a zipped-version too.

    I have also sent you an email with an alternative email address.

    Kind regards,
    Bastien Mensink

Kanwaljit`

Hi Bastien,

May the couple Live 1000 years !

Nice to know you got the file….. Just curious to know whether the example was clear ?

Warm Regards
Kanwaljit

Bastien

Hello Kanwaljit,

Thank you for your email. The example is clear.
The problem is related to the fact that Excel doesn't handle long numbers (>15) very well.
A value such as 051030807030962272 is automatically changed to a value such as 5,10308E+16.
You need to change the numberformat in the cell to text to be able to work with values such as 051030807030962272 and then the utility works as expected.

Kind regards,
Bastien