Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 10-10-2020, 12:48 PM
DBenz DBenz is offline Date format that displays D/M/Y or just M/Y or just Y Windows 7 64bit Date format that displays D/M/Y or just M/Y or just Y Office 2010 32bit
Advanced Beginner
Date format that displays D/M/Y or just M/Y or just Y
 
Join Date: Dec 2014
Posts: 69
DBenz is on a distinguished road
Default

Hi, see attached.
note if I type a year I get a strange date, so I have to enter the year in the subject box else I cant log the year at all; and typing a month and year I get 01 of the month., so if I see 01 February I know to ignore the day, though it might in fact be 01 occasionally. 1in 33 or 31 or 28 or 29 chance !


I want Sept not September as well to keep column widths down.



DBenz
Attached Files
File Type: xlsx Photos subject and Storage Location v2 - forum.xlsx (9.2 KB, 7 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge field mistakenly interpret text format as date format alan6690 Mail Merge 0 09-02-2020 01:54 AM
Create Field That Displays Date+30, Office 2007 Papote Word 6 10-09-2016 02:47 PM
Date format that displays D/M/Y or just M/Y or just Y Date format but with Jan Feb mar etc how is this done ? DBenz Excel 3 12-21-2014 05:00 AM
Letter date changes when merging with Excel - not the format, the actual date! Smallweed Mail Merge 1 02-07-2014 06:00 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 05:30 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