Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004

    Question Unanswered: How to change excel fields value to another value?

    Hello, I need help. I have an excel sheet where I have a cells with values:
    TRSMED= 140,000.00
    TRSPOT= 20,000.00
    TRSMAT= 0.00
    I want to know how to convert :
    TRSMED to 333990
    TRSPOT TO 333991
    TRSMAT TO 333992
    In order to get:

    333990= 140,000.00
    333991= 20,000.00
    333992= 0.00

    I will appreciate all sugetions.

    Thank You


  2. #2
    Join Date
    Mar 2004
    Fort Worth, Texas, USA
    Is TRSMED a single cell or a column of cells? Either way, you can just create a new name with Insert, Name, Define...

    However, you cannot create a name that is literally 333990. All range names must start with a letter or an underscore and cannot be a valid A1-style reference, such as D12.
    Last edited by actuary; 05-16-04 at 12:27.

  3. #3
    Join Date
    Mar 2004
    Greenville, SC
    You could just insert a column after your column with TRSMED, TRSPOT, etc.
    then in the new column next to TRSMED(Cell A1) put in 333990(Cell B1) and next to TRSPOT(Cell A2) put in 333991(Cell B2). Once you have done this you can highlight Cell B1 and B2 only. Then drag the little black plus sign in the bottom corner of Cell B2 to automatically fill in the sequential numbers.

    Hope this helps!

    Gotta to do some code

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts