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

    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

    Pl

  2. #2
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas, USA
    Posts
    68
    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
    Location
    Greenville, SC
    Posts
    271
    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!

    Michael
    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
  •