?Val("0344 0062 012 0000" )/10000 3440062012 HTH Van T. Dinh MVP (Access)
V Van T. Dinh Oct 21, 2003 #1 ?Val("0344 0062 012 0000" )/10000 3440062012 HTH Van T. Dinh MVP (Access)
M Michel Walsh Oct 21, 2003 #2 Hi, And to remove the first zero of each sequence, before the "agglutination": ? Val( Replace("0344 0062 012 0000", " 0", "") ) /1000 assuming Access 2000 or later, and that the last sequence is always four zeros. Vanderghast, Access MVP
Hi, And to remove the first zero of each sequence, before the "agglutination": ? Val( Replace("0344 0062 012 0000", " 0", "") ) /1000 assuming Access 2000 or later, and that the last sequence is always four zeros. Vanderghast, Access MVP
V Van T. Dinh Oct 21, 2003 #3 Thanks for catching that, Michel. I read quickly and thought that the O.P. meant the *very* first zero.
Thanks for catching that, Michel. I read quickly and thought that the O.P. meant the *very* first zero.
