Change date format

Closed
tariq - Dec 2, 2014 at 11:18 AM
 Blocked Profile - Dec 2, 2014 at 02:16 PM
Hello,
Change date format dd.mm.yyyy to dd/mm/yyyy for excel 2007

1 reply

Blocked Profile
Dec 2, 2014 at 02:16 PM
You can format text with the following:

=text(whatcellvalue,whatformat)

So, with the above function we can change the text in cell A1 to what ever format we choose, as in : =TEXT(A1,"DD/MM/YYYY")

Have fun!
0