First, set up a model cell with the replacement formatting. Next, press Ctrl+H to launch the Find and Replace dialog. There, define both the Find What and Replace With formatting by clicking "Choose ...

When you enter a date that's formatted with slashes, Excel will recognize it as a date. For example, Excel will automatically choose the date format for a cell that contains 11/11/19. You can set ...

If you’re a full-time spreadsheet jockey, or just a casual number-cruncher, you’ve come to know and either love or hate Excel’s interface. Well, your world just changed. Throw away almost everything ...