Convert alphabets to numeric values

kjxavier · #3 07-05-2014, 11:34 PM

Quote:

Originally Posted by macropod

You could use a macro like:

Code:

Sub NumberStringToNumeric()
...
End Sub

Note: the code assumes your number strings don't include the 'and' that is common in UK English, for example (e.g. one hundred and one). It's also not really designed for handling currencies or decimals, though it should handle the numeric aspects of those OK too.

Thank you for the effort and time! WE APPRECIATE THAT A LOT

can you please write me a macro which does the opposite as well

i.e:

742111.37
676736.06

=
SEVEN HUNDRED FORTY TWO THOUSAND ONE HUNDRED ELEVEN AND THIRTY SEVEN CENTS

SIX HUNDRED SEVENTY SIX THOUSAND SEVEN HUNDRED THIRTY SIX AND POINT SIX CENTS

NOTE: " AND POINT SIX CENTS means .06"

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sorting Alphanumeric & Numeric values	slovenc0417	Excel	2	06-07-2013 07:58 PM
Handle Text / Numeric values in SSRS while Export To Excel	achuki	Excel	5	02-07-2012 02:14 PM
Convert numeric value into words	KIM SOLIS	Excel	5	09-12-2011 10:53 PM
[How To] Generate Alpha Numeric Values in Excel 2010	stnicholas81	Excel	1	07-25-2011 01:31 AM
Running alphabets at left margins and pinpoint cites at right margin	ghumdinger	Word	3	05-05-2011 02:01 AM