Member Avatar for omrsafetyo

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
  • 148 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by omrsafetyo
Member Avatar for omrsafetyo

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.