Do you read CSV files? If so, change the name of the file to a .TXT file. Then you will have the opportunity to format each field
the way you like.

--
Kind regards,

Niek Otten

"Harmitage" wrote in message ...
| How do I stop excel automatically changing entiries with a / to a date? I am
| downloading data such as 7/1 so formatting the cells as text beforehand
| doesn't work.