ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I change a numerical value to a string value ? (https://www.excelbanter.com/excel-programming/357610-how-do-i-change-numerical-value-string-value.html)

Tony Guzzo

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 ?

PaulD

How do I change a numerical value to a string value ?
 
copy - paste special - values

"Tony Guzzo" wrote in message
...
: 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[_2_]

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" wrote in message
...
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 ?





All times are GMT +1. The time now is 12:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com