Skip to content

Instantly share code, notes, and snippets.

@bferronato

bferronato/Excel converte data

Created July 12, 2017 19:08
Show Gist options
  • Save bferronato/1393d147a4766871a9fbb0ecaec1171d to your computer and use it in GitHub Desktop.
Save bferronato/1393d147a4766871a9fbb0ecaec1171d to your computer and use it in GitHub Desktop.
Download ZIP
Converter data no Excel do formato MM/DD/AAA para DD/MM/AAAA
Raw
Excel converte data
Converter data no Excel do formato MM/DD/AAA para DD/MM/AAAA
=DATA(DIREITA(F42;4);ESQUERDA(F42;2);EXT.TEXTO(F42;4;2))
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment