Spreadsheet Formulas

css navigation by Css3Menu.com

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-2017

Updated:  11/07/2017 18:44
This page added:  15 May 1997