Remember Me?

 excel_noob Junior Member First recorded activity by ExcelBanter: May 2012 Posts: 2 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

 joeu2004[_2_] external usenet poster First recorded activity by ExcelBanter: Jul 2011 Posts: 829 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 base-26 arithmetic. For
example, numbers from 0 to 675 can be represented by the 2-letter
combinations formed as follows:

CHAR(65+INT(A1/26))&CHAR(65+MOD(A1,26))

 excel_noob Junior Member First recorded activity by ExcelBanter: May 2012 Posts: 2 Quote:
 Originally Posted by joeu2004[_2_] "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 base-26 arithmetic. For example, numbers from 0 to 675 can be represented by the 2-letter combinations formed as follows: CHAR(65+INT(A1/26))&CHAR(65+MOD(A1,26))

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

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post Luke Androsiglio Excel Worksheet Functions 2 March 31st 10 06:29 PM Krefty Charts and Charting in Excel 2 October 8th 07 12:25 AM AlexG Excel Worksheet Functions 3 July 26th 07 01:46 PM Jo Excel Discussion (Misc queries) 4 October 8th 06 11:37 PM cfitz New Users to Excel 4 February 5th 05 06:08 PM

All times are GMT +1. The time now is 01:02 PM. Copyright ©2004-2019 ExcelBanter.