|
|
OverPunch Code
=IF(B19<0,TEXT(ABS(LEFT(B19,LEN(ABS(B19-1))))&VLOOKUP(VALUE(RIGHT(B19,1)),LookSee,2,FALSE),"0"),B19)
Look at the number in cell B19.
If it is a negative number, make it absolute or positive, convert it to text, grab the rightmost digit of the number, take that digit and use a lookup table in ‘LookSee’ to find a converter and tack that on the end of the new number.
After I did all this, I decided it was too long to re-type every month and converted it to a user-defined function.
©
1997-2008
| Updated: | 04/02/2008 19:33 |
| This page added: | 15 May 1997 |
|