Putting a DATE in a formula ------ Possible?

[sssb2000]

hi,
i have a date (9/14/2012 for example) that's entered in A1 and may change automatically....
in B1, I'd like to have a formula like this: =ON & " " & A1 that would look like: ON 9/14/2012 in this case, and would update according to the updated date in A1.

the problem is that right now, the date is not showing up correctly in B1. is what i'm trying to do possible?

 

[Jonmo1]

Try

="ON " & TEXT(A1,"m/d/yyyy")

 

[Robert Mika]

or you can use Custom Format:
Excel 2010

	A	B	C
1	9/14/2012		ON 9/14/2012

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula C1 =A1 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

The format in C1:
"ON "m/d/yyyy

 

[sssb2000]

Great. many thanks!