View Single Post
  #1   Report Post  
excel_noob excel_noob is offline
Junior Member
 
Posts: 2
Default 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