Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-11-2022, 01:54 PM
trevorc trevorc is offline Displayed date not showing correct format Windows 7 32bit Displayed date not showing correct format Office 2013
Competent Performer
Displayed date not showing correct format
 
Join Date: Jan 2017
Posts: 173
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default Displayed date not showing correct format

Hi All,


this is a strange one, when i format a cell for date= dd/mm/yy the date entered as 12/1/22 is shown as 1/12/22 in the cell, but in the formula bar is is showing correctly as 12/1/22
We use international date format not US

Any ideas as to why to is happening ???

regards
Trevor
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Date is displayed in the wrong format shawn.low@cox.net Mail Merge 1 12-28-2019 02:17 AM
Displayed date not showing correct format Why is the date/time of comments (and other changes) not displayed in balloons or Reviewing Pane? paulkaye Word 2 12-31-2015 12:38 AM
Displayed date not showing correct format Mail Merge with correct format amentinho Mail Merge 14 10-10-2015 09:23 PM
Displayed date not showing correct format Way to get date on each slide correct? AZG PowerPoint 1 03-18-2015 07:20 AM
Displayed date not showing correct format Correct Format needed TonyB Mail Merge 3 05-03-2011 01:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:53 PM.


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