|
NC IA | I think I figured it out!Highlight or select the cells you want to apply this to. (Or, you can apply it to a single blank cell, apply it, and copy dragdown works also, to format.)Under the home page header, go to the number format selection. Drop down the entry bar, and click on the more number formats at the bottom.Next, click on custom.Next, type m/d/“23” in the “Type:” window.Click OK, and Walla! I wish I would have known this 20 years ago, it literally would have saved me a million keystrokes!
 (36224161-5156-4083-ABF2-ABCCB091995D (full).jpeg)
 (9CE01E71-2D77-4A46-B0CA-70A1CEF99802 (full).jpeg)
Attachments
----------------
 36224161-5156-4083-ABF2-ABCCB091995D (full).jpeg (156KB - 111 downloads)
9CE01E71-2D77-4A46-B0CA-70A1CEF99802 (full).jpeg (186KB - 112 downloads)
| |
|
Is there a way to change default year to 2023 for data entry in Excel?
