![]() ![]() These format codes are the same as the codes discussed in Method 2. dateformatcode is the format code that specifies how you want the resulting date to look. Selection.PasteSpecial Paste:=xlPasteValuesĪpplication. TEXT (dateinput, dateformatcode) In the above formula syntax: dateinput is the date value or a reference to a cell containing a date that you want to apply the Short Date format to. ‘ Created by Francis Hayes (The Excel Addict) If TypeName(Selection) “Range” Then Exit Function Also, you’ll have to link the hotkey combination yourself (alt+F8 to get to where that can be done). I recommend adding this code to your Personal.xlsb file so that it’s available from all spreadsheets. This will require some understanding of VBA. There are also a few others I have that are also great for pasting just format, just column width, or just formula. I you want to try you hand at using macros, this one is great - I use this constantly. There are other methods too, so please leave a comment below if you use a different shortcut. The Excel shortcut we will show you allows you to get to the bottom of the data with a single. Please leave a comment below with your favorite. Paint & glue required, not included New (15) from 93. I'd love to know which method you use for pasting values. If you're more of a mouse user then checkout my article on my favorite mouse for Excel. ![]() In the video I also mention my article on the best keyboards for Excel keyboard shortcuts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |