N
njhagan
Hi, This is silly but...
I have created a template on ms excel 2000 for printing my compan
cheques and what I wanted to know was:
Can I create a formula or macro so that when I write a number in tex
(such as 'one' or 'two' or 'three', etc) in the cell representing th
word part of my cheque, can I get that number (as '1' or '2' or '3'
etc) to appear in another cell representing the numerical part of m
cheque.
This is a lazy man's burden but I thought it would also suffice as
check that the right amount was going on both parts.
Sorry for the bother but ..
Attachment filename: chq layout.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=41496
I have created a template on ms excel 2000 for printing my compan
cheques and what I wanted to know was:
Can I create a formula or macro so that when I write a number in tex
(such as 'one' or 'two' or 'three', etc) in the cell representing th
word part of my cheque, can I get that number (as '1' or '2' or '3'
etc) to appear in another cell representing the numerical part of m
cheque.
This is a lazy man's burden but I thought it would also suffice as
check that the right amount was going on both parts.
Sorry for the bother but ..
Attachment filename: chq layout.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=41496