Insert apostrophe in front of a date

Originally Posted by Paul B

Have a custom report that requires an apostrophe before the date for each record. Vendor changed the format on me and removed the apostrope now I need a formula to insert it in front of each date in the column without changing anything else.

Hi,

If the format has changed then I presume that the cell now contains a number in the 30000 range, so simply adding a ' single quote won't help.

How many of the cells in the column are dates?

Are the dates in the column in cells formatted as 'Text'?

How do you identify any other data in the column?

Is it possible that =TEXT(A1,"dd/mm/yyyy") would obviate the need for the ' (single quote) ?

---