Suppose you have a column of figures in Excel, say, a long one having hundred entries , and you have to write the equivalent in words corresponding to that figure, say, 1 should be reported as 'one' and 2367 should be reported as 'Two Thousand Three Hundred Sixty Seven'. This macro can come in handy. written in VBA (Visual Basic for Applications).
Sunday, October 27, 2013
Converting Figures to Words in Excel Column using VBA
Suppose you have a column of figures in Excel, say, a long one having hundred entries , and you have to write the equivalent in words corresponding to that figure, say, 1 should be reported as 'one' and 2367 should be reported as 'Two Thousand Three Hundred Sixty Seven'. This macro can come in handy. written in VBA (Visual Basic for Applications).
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment