Creating fixed information in a cell

K

Kay

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!
 
M

Marcelo

Hi Kay,

="From: "&a2

assuming the date is in A2

hth
regards from Brazil
Marcelo

"Kay" escreveu:
 
S

Sloth

Use a custom format like this

"From:" @

when you type in something like "test" in the cell it will look like this

Form: test
 
D

Dave Peterson

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!).
 
Top