Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-06-2013, 09:28 AM
Tamarrissa Tamarrissa is offline Date Value Format Error Windows 7 64bit Date Value Format Error Office 2007
Novice
Date Value Format Error
 
Join Date: Nov 2012
Posts: 3
Tamarrissa is on a distinguished road
Default Date Value Format Error

I can't seem to get the date to format properly from excel. This is what I've entered:



{ MERGEFIELD M_10 \@ "dd/MM/yyyy" }

But it still views as the excel value "40623", not "21/03/2011"
Attached Files
File Type: docx 5066 - Employee File - New Hire.docx (17.8 KB, 10 views)
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Value Format Error Date format switch with If statement sbarron76 Mail Merge 3 05-03-2013 06:23 AM
Help with Date Format and truncating a field mr starface Mail Merge 2 04-29-2013 07:08 AM
Date Value Format Error Timeline date format mikeg Project 1 04-19-2013 06:26 AM
Date Value Format Error MS Query date format remigio Word 3 08-21-2012 10:54 PM
date format gsrikanth Excel 1 12-28-2011 05:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft