custom format
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. |
custom format
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. "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. |
custom format
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 "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. |
custom format
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. |
All times are GMT +1. The time now is 11:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com