Forum Discussion
Formulas and Functionsn
Hi,
How to change format in
=TODAY()+5
to dd-mm-yyyy format?
- Use TEXT() function to apply the desired format. =TEXT(TODAY()+5,"dd-mm-yyyy"). You also apply same format to cell formatting rule.
- Use TEXT() function to apply the desired format. =TEXT(TODAY()+5,"dd-mm-yyyy"). You also apply same format to cell formatting rule.
It works – the result displayed is left-adjusted. But when I use =TODAY(), the result is displayed as right-adjusted in the cell. Thanks much, Harun! Good day.
- It works – the result displayed is left-adjusted. But when I use =TODAY(), the result is displayed as right-adjusted in the cell. Thanks much, Harun! Good day.
The left and right adjustment is simply Excel's default formatting for text and numbers respectively. Unless you specifically require text formatting, the normal approach would be to use number formatting (dropdown on the 'number' group on the Home ribbon tab) which allows you to define formats that vary from your normal system settings.
