Excel shortcut for month day year short date closed

0 votes
Dates are formatted in Excel using the shortcut (CTRL+SHIFT+#) as dd-mm-yy (with month abbreviated). Is it possible to modify the shortcut's format to m/d/yyyy?

Consequently, on August 6, 20016, currently CTRL+SHIFT+# => 6-Aug-16, but how can I get CTRL+SHIFT+# => 8/6/2016?
Jan 3, 2023 in Others by Kithuzzz
 • 38,000 points • 814 views

1 answer to this question.

0 votes

What about Ctrl-1 + Tab + Tab + Tab + Up (If Ctrl-1 starts you in the Custom Category)

In  Excel 2010:

  1. Select both cells 05-Aug-16, 06-Aug-16
  2. Ctrl-1 + Tab + Tab + Tab + UpArrow
  3. 05/08/2016 , 06/08/2016
answered Jan 3, 2023 by narikkadan
 • 63,600 points

Related Questions In Others

0 votes
1 answer

Excel: Formula for compound interest for monthly deposits where deposits increase every year

It's possible that I don't understand how ...READ MORE

answered Nov 26, 2022 in Others by narikkadan
 • 63,600 points • 2,766 views
0 votes
1 answer

Excel - Find the Max for Total revenue just for year 1

In Office365 and LibreOffice Calc, there is ...READ MORE

answered Jan 8, 2023 in Others by narikkadan
 • 63,600 points • 400 views
0 votes
1 answer

Best way to get average values within a specific set of time(say, date or year) using MySQL or Rails

I don't think post-process is what you ...READ MORE

answered Nov 8, 2018 in Others by DataKing99
 • 8,250 points • 3,088 views
0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9, 2022 in Others by gaurav
 • 23,260 points • 1,653 views
0 votes
1 answer

"Advance" an Excel formula via keyboard shortcut while in edit mode?

As requested, you can carry out the ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
 • 63,600 points • 448 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
 • 26,740 points • 1,260 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
 • 58,020 points • 1,125 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
 • 58,020 points • 4,395 views
0 votes
1 answer

Excel Date separate with =DAY(), =MONTH() and =YEAR()

If it must be done inside of ...READ MORE

answered Mar 20, 2023 in Others by narikkadan
 • 63,600 points • 629 views
0 votes
1 answer

Excel plot against a date time x series [closed]

Try using an X-Y Scatter graph with ...READ MORE

answered Oct 22, 2022 in Others by narikkadan
 • 63,600 points • 615 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.