新聞財經娛樂♬資訊 News Economy

Hi,
I have a spreadsheet with names and dates to be printed onto certificates.
The dates are formatted in excel to look like "9 July 2014" but when you double-click the cell it reads 9/7/14 in the formula bar. and in the print software it's picking up as "9/7/14"
Is there not a way to copy the formatted date text from that column and paste it as text instead of as a date?
Thanks
Steve

you can convert it to text from A1="9  Jan 2014" to B1 with this formula

=TEXT(B1,"dd mmmm yyyy"),

 Is it what you need?

Duncan

If you are not using the date for any calculations convert it to text using the following formula, assuming date in column B:

=TEXT(B2,"dd mmmm yy")

Then copy and paste values to overwrite if so required.

Thanks
Rob H