Consulting

Results 1 to 4 of 4

Thread: Help Adding a constant text to a numeric cell

  1. #1
    VBAX Newbie
    Joined
    Sep 2007
    Posts
    2
    Location

    Help Adding a constant text to a numeric cell

    Excel 2003 and I just completed a 2 day class but I am stumped. I am trying to write code to add a text (SF-300) to a column of 3 digit numbers starting from 100-999. Can someone help me . I know if I get started I can do it to other columns I have.

    Thanks

  2. #2
    VBAX Expert
    Joined
    Aug 2004
    Posts
    810
    Location
    = A1 & "SF-300"

    Enter the above formula, change A1 to suite. Do a fill down.

  3. #3
    That could work but you'd lose use of the numbers.
    Go to format cells custom and then enter something like #" SF-300"
    include the quotes !!!
    2+2=9 ... (My Arithmetic Is Mental)

  4. #4
    VBAX Newbie
    Joined
    Sep 2007
    Posts
    2
    Location
    That works thanks. Geez guess I didnt need code eh.

    Thanks

Posting Permissions

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