If condition

Excel Help for If Condition in Analyzing Corporate Financial Data

If Condition

Rate this: (3/5 from 1 vote)

	you can use a function. see this url http://www.ozgrid.com/VBA/CurrencyToWords.htm copy paste this function preferabley in personal.xls file  suppose A1 has 1 or 2 or 3 etc type in B1 =convertdigit(A1) do you get what you want.   [/code] Private Function ConvertDigit(ByVal MyDigit) Select Case Val(MyDigit)             Case 1: ConvertDigit = "One"             Case 2: ConvertDigit = "Two"             Case 3: ConvertDigit = "Three"             Case 4: ConvertDigit = "Four"             Case 5: ConvertDigit = "Five"             Case 6: ConvertDigit = "Six"             Case 7: ConvertDigit = "Seven"             Case 8: ConvertDigit = "Eight"             Case 9: ConvertDigit = "Nine"             Case Else: ConvertDigit = ""          End Select End Function  [/code]
	Posted by [email protected] on 05 Jan 2009

View Full Post