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?
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?