
OverPunch Code
=IF(B19<0,TEXT(ABS(LEFT(B19,LEN(ABS(B191))))&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 retype every month and converted it to a userdefined function.

©
19972024
Updated:  01/23/2024 13:34 
This page added:  15 May 1997 
