98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel date formatting
Excel date formatting
Resolved · Medium Priority · Version 2003
Wed 10 Sep 2008, 10:28Delegate Joanna said...
Joanna has attended:
Access Intermediate course
Excel date formatting
When using Excel for a mail merge we are finding that when the dates listed are merged to the word document they are being displayed in American format despite being typed in UK format in the cells and the column has been set to dd/mm/yyyy format UK (English). Does anyone have any ideas how to stop this happening?
Thanks, Joanna
Thu 11 Sep 2008, 14:03Trainer Alan said...
RE: Excel date formatting
Hi Joanna
I can only guess that because Excel dates are really nu,mbers formatted to look like dates there is something in the programming on the merge process that converts them to native microsoft format.
My suggestion would be to type the dates in Excel using text format e.g. 26th September 2008. The merge process should then merge the text rather than convert a number, and the dates should display in Word as required.
Hope it works!
Alan Burbridge
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Random NumbersType =RAND()*200 to generate a number between 1 and 200. |
