1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.NE

  • How do I use letters to represent numbers?

    From johannab864@gmail.com@21:1/5 to All on Mon Feb 24 09:51:55 2020
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)