Thread: custom format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JPS[_2_] JPS[_2_] is offline
external usenet poster
 
Posts: 7
Default 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.