Thread: [Solved] Date formatting
View Single Post
 
Old 08-08-2011, 05:33 AM
kjxavier kjxavier is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Jul 2011
Posts: 39
kjxavier is on a distinguished road
Default Date Formatting

Quote:
Originally Posted by OTPM View Post
Hi Xavier
This is happening because the date formnat in the other program is set differently. For example of your documents are based on different templates they may have differing date formats and this is what is causing the issue.
Hope this helps.
Tony(OTPM)
Hi TONY

Please check with the File attached.

The fields display the desired format. But still the Formula Bar displays the format of Excel (org) maybe and that format displayed on the Formula bar is my problem. (is there anyway dat i can change the format of the formula bar)
Attached Images
File Type: jpg Excel-1.jpg (9.0 KB, 8 views)
File Type: jpg Excel-2.jpg (14.7 KB, 8 views)
Reply With Quote