Feb 21, 2017 · Forum Microsoft Office Application Help - Excel Help forum Excel Formulas & Functions [SOLVED] Looking for a formula to convert American dates to British dates.

Apr 12, 2006 · I'm pretty basic when it comes to Excel. How can I change the date format for the date field that I've placed in my footer? I would like it to show 04-11-06. Thanks. Terry S.

Jun 7, 2025 · Re: Format Date in Textbox You're Welcome. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as …

Jul 10, 2019 · The issue I'm having is converting imported text in the format "Jul-21" to a date format excel recognizes as the 1st date of the month from the given text. For example, "Jul-21" …

Oct 1, 2018 · 2) Format axis as date axis (if Excel does not do so automatically) and set Major unit to 1 year. At this point, I did notice that Excel still seems to plot the second data series …

Nov 9, 2017 · Re: Making date format two digits for month/two digits for day/four for the year - so hard Try to "Custom Format" the cells to mm:dd:yyyy, it should work.

Sep 22, 2007 · Hello, I have dates formatted in a spreadsheet as MM/DD/YYYY and I need to remove the "/" to get the format MMDDYYYY. In some cases, I even have M/D/YYYY, where I …

Feb 26, 2007 · I have imported a DBF file into Excel and have a column of dates that are missing the leading zero on single didgit months. When I try to us the custom format of mm/dd/yyyy it …

Sep 11, 2015 · Re: Dates showing as number instead of mm/dd/yy Highlight the column then select 'format cells'>'date'?

Jan 8, 2009 · hello just wondering if its possible to format a cell to display date and week number and if so how to go about it eg 04/01/09 week 1