TEXT formatting
Saturday, August 18, 2018
09:14
Note: Although you can use the TEXT function to change formatting, it’s not the only way. You can change the format without a formula by pressing CTRL+1 (or  Image of the MAC Command button icon +1 on the Mac), then pick the format you want from the Format Cells > Number dialog.