Change date format

[Closed]
Report
-
 Blocked Profile -
Hello,
Change date format dd.mm.yyyy to dd/mm/yyyy for excel 2007

1 reply


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!