custom format

[JPS]

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.

 

[Sean Timmons]

If the goal is to get 3, then how about:

=RIGHT(A1,LEN(A1)-FIND(" ",A1))+RIGHT(A2,LEN(A2)-FIND(" ",A2))

Then you can enter Day 1 and Day 2, and it will calculate for you.

 

[FSt1]

hi
right click the cell(s) that you want to custom format
from the popup, select format cells.
on the number tab, select custom
enter this...
"Day" 0
enter a 1 in the formated cell. Day 1 will appear.
when summing, the fomula may pick up the custom format. reformat to general
or other.
regards
FSt1

 

[Gord Dibben]

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