B
Brian Vargo
Our business software doesn't allow us to easily print off a quick
cheque to payees that are not first established as vendors. I am
trying to set up an excel cheque template to allow me to manually print
off a cheque that I can later enter into our system.
I would like to enter the amount in one cell and have another cell
where that amount is converted automatically to a written
representation of the number. (ie: ***One thousand, three hundred and
twelve and 19/100 dollars***). I suspect that I would need to create a
macro that would peel off each individual digit and convert it to a
"text" digit, then combine all the text digits. Then fill remaining
room in the cell with "*" characters.
Am I on the right track? Does anyone have such a thing or know where I
could download it from?
cheque to payees that are not first established as vendors. I am
trying to set up an excel cheque template to allow me to manually print
off a cheque that I can later enter into our system.
I would like to enter the amount in one cell and have another cell
where that amount is converted automatically to a written
representation of the number. (ie: ***One thousand, three hundred and
twelve and 19/100 dollars***). I suspect that I would need to create a
macro that would peel off each individual digit and convert it to a
"text" digit, then combine all the text digits. Then fill remaining
room in the cell with "*" characters.
Am I on the right track? Does anyone have such a thing or know where I
could download it from?