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?
- Numeric keypad mac - Guide
- How to convert numeric to words in excel - Guide
- Numeric into words - Guide
- How to change a column to numeric in Excel? - Guide
- Which two sentences correctly describe the use of formulas in performing calculations in spreadsheets? all formulas written for a spreadsheet must follow certain rules, which we call syntax. when creating a formula in a spreadsheet, always start with an if statement. basic statements include numeric values and operators. if there are multiple operators, then the order of precedence starts with exponents. parentheses are used to isolate certain parts of the expression from the other parts. operations in parentheses are completed after the rest of the formula is evaluated. - 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)
