View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Creating fixed information in a cell

If you want to use a different cell:

="From: " & text(a1,"mm/dd/yyyy")

If you want to use the same cell, give it a custom format of:
"From: " mm/dd/yyyy

The nice thing about the second choice is that the value in the cell is still a
date--even though you see "From: " in the cell in the worksheet (but not in the
formula bar!).


Kay wrote:

Can anyone help me figure out how to keep a "fixed" word in a cell but add
information? For instance; I have a cell that says "From:" I would like to
keep that word fixed and be able to type a date after it without having to
retype From then the date. Is there a cure? Any help would be great!


--

Dave Peterson