-1

I need to change date from existing format to dd-MM-yyyy in excel .

EDIT : I have seen other formats , but they don't contain - dd-MM-yyyy format .

Yatin
  • 2,969
  • 9
  • 34
  • 68
  • Copy the title of your question and google it. – Sangbok Lee Apr 03 '17 at 07:02
  • 1
    You might want to read through this to better understand dates / times in Excel: http://stackoverflow.com/a/37101358/1153513 This is probably also a good read: http://stackoverflow.com/a/38001028/1153513 Afterwards, please check if these are true dates. If not then you will find in these posts some code to possibly convert them. If these are true dates then you'll find your answer here: https://support.office.com/en-us/article/Format-a-date-the-way-you-want-8e10019e-d5d8-47a1-ba95-db95123d273e – Ralph Apr 03 '17 at 07:02
  • This might help - https://social.technet.microsoft.com/Forums/en-US/f7525b14-2039-41b5-8aa9-6ac63fbb8233/change-date-format-in-ms-excel-2013-form-mmddyyyy-to-ddmmyyyy?forum=excel – MusicLovingIndianGirl Apr 03 '17 at 07:03
  • http://stackoverflow.com/a/34741424/4539709 – 0m3r Apr 03 '17 at 07:14
  • It does not have dd-MM-yyyy – Yatin Apr 03 '17 at 07:19

2 Answers2

3

Create your own Custom Number Format, entering dd-mm-yyyy:

Codes:

  • m = 4
  • mm = 04
  • mmm = Apr
  • mmmm = April

Custom Number Format

Michael
  • 4,563
  • 2
  • 11
  • 25
0

click on the cell then click ctrl+1 choose date then choose the format from type list

Amado
  • 371
  • 1
  • 16