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 SOLVED.

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" should be …

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 against the first …

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 will still need …

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 doesn't …

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