ExcelBanter - How do I disable automatic date formatting in excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I disable automatic date formatting in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/4412-how-do-i-disable-automatic-date-formatting-excel.html)

tcuneio

How do I disable automatic date formatting in excel?

I am importing data into Excel which contains codes. Some of the codes are
similar to dates (ex. 4feb1) and they are automatically converted. I need
the codes to remain as is.

Peo Sjoblom

Import it as text

Regards,

Peo Sjoblom

"tcuneio" wrote:

I am importing data into Excel which contains codes. Some of the codes are
similar to dates (ex. 4feb1) and they are automatically converted. I need
the codes to remain as is.

All times are GMT +1. The time now is 04:37 PM.