Custom Format of "Day "0

Do not format the cell with the =A1+A2

Or =SUM(A1:A10) if you have many cells to SUM


Gord Dibben MS Excel MVP

On Fri, 17 Oct 2008 16:13:46 -0400, "JPS" wrote:


In cell A1 I'd like to enter 1 and have it displayed as "Day 1"
In cell A2 I would like to enter 2 and have it display as "Day 2"

The goal is to be able to have a formula return 3 if I sum A1:A2.