Looking to break a large number down

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello DLW,

That works for my numbers, UNLESS the first number is a 0 (ie. 098 returns
as 9 | 8 | 8.

It's possible that I have to make it a text.. but when I tried it still
drops off the beginning 0. :(

Does anyone have any other suggestions or incorporate the =LEFT / MID / RIGHT

Thank You.
David
 
Hello Elkar,

I did try it yesterday and it didn't seem to work the way I wanted it to....
Now it seems it was a Id-10-T issue, I must have typed it incorrectly
yesterday because today it worked for me.

Thank You
David
 
Back
Top