How do we convert numbers to words. Especially useful if you are writing cheques (checks) through printing through a soft file. The logic given below is one for India – it uses crores and lacs. The logic works for all numbers between 1 and 99,99,99,999 (100 crore -1) Say the numbers that need to be [...]
Posts Tagged ‘Right’
Converting numbers to words
Posted in Tip, tagged concatenate, Left, Len, mid, proper, Right, rounddown, sum, value, vlookup on June 5, 2009 | 1 Comment »
Separating names into last and first names
Posted in Uncategorized, tagged Find, Left, Len, Right, Text to Columns.. on July 1, 2008 | Leave a Comment »
I had encountered this problem while carrying out mail merge. Usually names are stored in a single field. In order to carry out mail merge for a letter/mailer, last names needs to be stored in a separate field to faciliate merge as Dear Mr/Ms last_name The original list is stored in column A whereas the [...]
Author
Search blog
-
Recent posts
-
Blog Stats
- 15,059 hits
Share with others!
What have I used most
Get down to work!
May 2012 M T W T F S S « Jul 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
