date function

J

jiajin

Hi all

anyone can show me ,how i create a cell that can be join the date
function with text?
example
test.today()
to
test.11022006


thkx in adv
jiajin
 
S

SVC

Use custom formatting for the cell: Format > Cell, select Custom and enter
in the Type: "test."ddmmyyy (if you want day, month, year; otherwise use
mmddyyyy). Note: you need to include the quotation marks.
 
Top