Home 
Search 
Today's Posts 
#1




How do I use letters to represent numbers?
what i am looking for is
k=1000 M=1000000 G=1000000000 m=.001 ....ect i then what to be able to use this in calculations for example 5k +1k = 6000 i am trying to do this to make it easier to input the data and easier to read, the numbers get too big and i find i have to count places alot so i know what i am looking at thank you in advance for you help excel_noob 
#2




How do I use letters to represent numbers?
"excel_noob" wrote:
Subject: How do I use letters to represent numbers? Kinda light in details. For numbers from 0 to 25 in A1, for uppercase letters, use: CHAR(65+A1) For lowercase letters, use: CHAR(97+A1) For numbers that might be larger than 25, use base26 arithmetic. For example, numbers from 0 to 675 can be represented by the 2letter combinations formed as follows: CHAR(65+INT(A1/26))&CHAR(65+MOD(A1,26)) 
#3




Quote:
what i mean is that i want to input some value into a cell i.e. 6.6k which equals 6600 and in another 26mA which equals .026A for example. I then want to be able to use that in another calculation. 6.6k*26m which equals 171.6 the actual calculation does not need the k or m, but i do want to be able to just select the cell that holds the 6.6k and 26m for my calculations 
#4




How do I use letters to represent numbers?
On Sunday, May 20, 2012 at 12:31:45 PM UTC4, excel_noob wrote:
what i am looking for is k=1000 M=1000000 G=1000000000 m=.001 ...ect i then what to be able to use this in calculations for example 5k +1k = 6000 i am trying to do this to make it easier to input the data and easier to read, the numbers get too big and i find i have to count places alot so i know what i am looking at thank you in advance for you help excel_noob  excel_noob 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Custom Formating Letters to Numbers while Displaying Letters  Excel Worksheet Functions  
Excel Chart How do I create Y axis to represent numbers I am using  Charts and Charting in Excel  
Letters to represent numbers  Excel Worksheet Functions  
how do i program alphabet letters to represent numerical values?  Excel Discussion (Misc queries)  
how do i represent numbers with letters  New Users to Excel 