How to get Numeric value in to Text?
Closed
patildarshan27
Posts
1
Registration date
Saturday August 31, 2013
Status
Member
Last seen
August 31, 2013
-
Aug 31, 2013 at 02:48 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 31, 2013 at 06:54 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 31, 2013 at 06:54 AM
Related:
- How to get Numeric value in to Text?
- How to convert numeric to words in excel - Guide
- Numeric to words in word - Guide
- Hp laptop numeric keypad - Guide
- Macbook numeric keypad - Guide
- How to change a column to numeric in Excel? - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 31, 2013 at 06:54 AM
Aug 31, 2013 at 06:54 AM
engter this in L1 to M10
1 one
2 two
3 three
4 four
5 five
6 six
7 seven
8 eight
9 nine
0 zero
in A1 enter 125
in B1 type this formula
=VLOOKUP(LEFT(A1,1)+0,$L$1:$M$10,2,0)&" "&VLOOKUP(MID(A1,2,1)+0,$L$1:$M$10,2,0)&" "&VLOOKUP(RIGHT(A1,1)+0,$L$1:$M$10,2,0)
1 one
2 two
3 three
4 four
5 five
6 six
7 seven
8 eight
9 nine
0 zero
in A1 enter 125
in B1 type this formula
=VLOOKUP(LEFT(A1,1)+0,$L$1:$M$10,2,0)&" "&VLOOKUP(MID(A1,2,1)+0,$L$1:$M$10,2,0)&" "&VLOOKUP(RIGHT(A1,1)+0,$L$1:$M$10,2,0)
