0

I am trying to keep formatting between cell references.

For instance, I have a date in once cell (J9) and would like to add this date to a text field so e.g.:

="This will take effect on " & J9 & "."

However, when I do this, I end up with numbers...

"This will take effect on 172543."

I have googled for quite a while now, and tried many built in functions, including left, right, concatenate, datevalue, etc. etc. etc. and cannot find a solution for how to do this in a cell formula.

Any ideas?

1
Contributor
1
Reply
2
Views
8 Years
Discussion Span
Last Post by omrsafetyo
0

solved... I used another reference cell...
=TEXT(J9,"DD MMMM YYYY")

Which returns (for today) "26 January 2009".
I can then reference this cell elsewhere.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.