+ Reply to Thread
Results 1 to 3 of 3

How do I change a numerical value to a string value ?

Hybrid View

  1. #1
    Tony Guzzo
    Guest

    How do I change a numerical value to a string value ?

    Jan Feb Mar
    A1 A5 A5 A5
    A2
    A3
    A5=Sum(A1:A3)

    At the end of Jan, how can I make A5 not change so in Feb there will be new
    numbers ?

  2. #2
    PaulD
    Guest

    Re: How do I change a numerical value to a string value ?

    copy -> paste special -> values

    "Tony Guzzo" <[email protected]> wrote in message
    news:[email protected]...
    : Jan Feb Mar
    : A1 A5 A5 A5
    : A2
    : A3
    : A5=Sum(A1:A3)
    :
    : At the end of Jan, how can I make A5 not change so in Feb there will be
    new
    : numbers ?



  3. #3
    Luke Alcatel
    Guest

    Re: How do I change a numerical value to a string value ?

    Your question doesn't convey a sense of what problem you are trying to
    solve.
    - Are you asking about a timing trigger that will fire at the end of each
    month?
    - Are you asking how to write an Excel macro?
    - Are you asking how to write VBA code?
    ???

    Luke

    "Tony Guzzo" <[email protected]> wrote in message
    news:[email protected]...
    > Jan Feb Mar
    > A1 A5 A5 A5
    > A2
    > A3
    > A5=Sum(A1:A3)
    >
    > At the end of Jan, how can I make A5 not change so in Feb there will be

    new
    > numbers ?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1