Word 2002 Add-in: Microsoft Convert Number Smart Tag

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is this add-in available for Word 2003? I wish to convert numbers to words eg.
1 to one in a Word table.
It is for receipts. The table has a cell which shows the total amount paid
(formula cell) from the above rows. I then have the cell underneath the
formula cell, to show the value in words. This is to confirm no that no
tampering of the $ value of the receipt has occurred when client presents it.

What you have paid
Term 1 2005 10.00
Term 2 2005 10.00
Term 3 2005 10.00
Term 4 2005 10.00
Term 1 2006 10.00
Total Paid 50.00

50.00 (This is the cell that I wish to have showing as Fifty Dollars
automatically)
 
How does expressing the number in words prevent tampering? Surely if the
user can change the digits, they can change the words too?
 
If the number is a field, you can use the \*CardText or \*DollarText switch.
See the Help topic "Format (\*) field switch."

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Thank you Suzanne, your answer was exactly what I was looking for. I have
gone ahead and given it a try and it worked beautifully.
Thanks heaps.
 
It is useful on an original receipt, as numbers can be easier to change than
words. For example a 0 can be discreetly changed to an 8 but the word zero
cannot be changed to the word eight without detection. This is a standard
accounting practice in the issuing of receipts which can help to deter
people. However it is not the be all and end all of deterents by any stretch
of the imagination in scenario's when someone is determined to tamper with
it. Hope this helps.
 
I take your point, but with my auditor's hat on I think it's dubious. A
defective control may be worse than no control at all, in that it gives a
false sense of security. If you need to verify the receipt, you need a
trusted cross-check; otherwise you are, in fact, taking the receipt at face
value.
 
I appreciate your concern. However the originals of these receipts are never
sighted by our organisation again as they are presented to a Government
Department by the client. That then becomes that particular Department's
concern with the validity of the dollar value and if they are concerned in
any way they are able to contact us and check our records. The Department
has a standard criteria requirement for receipts and so long as we meet their
criteria then it is up to them to detect any fraudulent changes. They can
choose to take them at face value or contact our organisation. Having worked
in that particular Government Department myself for 12 years also in an
auditing capacity, I'm am quite sure that they will cope with any scenario.
The criteria that they require in the issuing of these receipts has been met
by our organisation in full and more due to our diligence, so I have no
problem with it. I would also doubt that this particular Government
Department would deal in defective controls considering they have vast
resources and advice available to them from the legal, accounting and fraud
detection world.
As they say - the only difference between a burgled house with an open door
and a burgled house with a locked door is a smashed window... it depends on
how determined a person is but hopefully they will get caught in the end and
they have. This is speaking from personal experience.
I appreciate your reply and thank you for your interest. I have not posted
the entire receipt on the net and so I appreciate you have only part of the
scenario and this at times can be a little misleading but your comments are
valued.
 
Back
Top