Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Cell as custom type but data doesn't display like I custom. | Excel Discussion (Misc queries) | |||
Excel 2003. Custom format gets replaced by Special format. | New Users to Excel | |||
ignore auto format after applying a custom format?? | Excel Discussion (Misc queries) | |||
Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) |