CHANGE COLOR
  • Default color
  • Brown color
  • Green color
  • Blue color
  • Red color
CHANGE LAYOUT
  • leftlayout
  • rightlayout
SET FONT SIZE
  • Increase font size
  • Default font size
  • Decrease font size
Personaliseer homepage

SmartSell

Home Code Excel

Excel

Change date to text

E-mail Print PDF

Assuming your date is in A1, enter the following formula in some other cell:

=TEXT(A1,"dd/mm/yy")

You can change the format "dd/mm/yy" to fit your requirement.

If you want to keep the date in cell A1 but change it so that it acts like text instead of like a date, enter an apostophe( ' ) in front of the date.
Alternatively, you can format the cell as text before entering the date.