View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
[email protected] johannab864@gmail.com is offline
external usenet poster
 
Posts: 1
Default How do I use letters to represent numbers?

On Sunday, May 20, 2012 at 12:31:45 PM UTC-4, 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