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

[Guest]

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 ?

 

[PaulD]

copy -> paste special -> values

: 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 ?

 

[Luke Alcatel]

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