Spreadsheet Formulas

css navigation by Css3Menu.com

OverPunch Code


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

Updated:  11/16/2016 19:50
This page added:  15 May 1997