# COMO CAMBIAR UNA FECHA QUE VIENE EN EXCEL EN FORMATO TEXTO QUE SE MUESTRA COMO UN NUMERO '44075' A FORMATO FECHA EN KNIME? **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [October 6, 2020, 3:11pm UTC](https://forum.knime.com/t/como-cambiar-una-fecha-que-viene-en-excel-en-formato-texto-que-se-muestra-como-un-numero-44075-a-formato-fecha-en-knime/27849 "2020-10-06T15:11:08Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\ **Post date:** [October 6, 2020, 3:35pm UTC](https://forum.knime.com/t/como-cambiar-una-fecha-que-viene-en-excel-en-formato-texto-que-se-muestra-como-un-numero-44075-a-formato-fecha-en-knime/27849/2 "2020-10-06T15:35:09Z")
@MSteven0420 welcome to the KNIME forum. I hope this thread might help you. There also is a sample workflow that shows the conversion of an excel string into a date format: > [@Noob Help: Convert date value to dd/mm/yyy](https://forum.knime.com/t/noob-help-convert-date-value-to-dd-mm-yyy/19757/4): > > Great - there’s the magic secret… according to [this](https://excel.officetuts.net/en/training/how-excel-stores-date-and-time) the epoch is new year’s day 1900, and each number is a day since. You could use the date & time shift node - but that seems like a pain in the ass. Here’s a workflow. Perhaps you could export the dates in a different format (like an YYYYMMDD string or milliseconds since epoch or …) for which there are nodes that do this conversion specifically. [plunket excel number to date.knwf](https://forum-cdn.knime.com/uploads/default/original/2X/4/4be6cc222cccf2130fb7f644e209d45919fdc310.knwf) (6.8 KB) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/8/b/8b2f7a7b7434ea74e0c1c71c8d465846d7464c63.png) > **[convert excel number (or string) to date – mlauber71](https://hub.knime.com/mlauber71/spaces/Public/forum/kn_forum_27849_excel_number_to_date~DuZ0wApoBs26cYg_/current-state)** > > convert excel number (or string) to date strange enough this shift at the moment ends up with converting 44075 to the 3rd of sept 2020 instead of the 1st … --- _[View the full topic](https://forum.knime.com/t/como-cambiar-una-fecha-que-viene-en-excel-en-formato-texto-que-se-muestra-como-un-numero-44075-a-formato-fecha-en-knime/27849)._