Skip to main content

Return to Question

Question Protected by CommunityBot
Question Unprotected by brettdj
Question Protected by CommunityBot
fixed title, grammar, added tag
Source Link
edit approved Jun 21, 2012 at 2:03
JimmyPena
edit approved Jun 21, 2012 at 2:03
JimmyPena
  • 8.8k
  • 6
  • 46
  • 66

CSV file. Excel is Stop Excel from automatically converting mycertain text values to a date. Bad Excel.dates

Does anyone happen to know if there is a token I can add to my csv for thisa certain field so Excel doesn't try to convert it to a date?

I'm trying to write a csv.csv file from my application and one of the values happens to look enough like a date that Excel is automatically converting it from text to a date. I've tried putting all of my text fields (including the one that looks like a date) within double quotes, but that has no effect.

CSV file. Excel is automatically converting my text to a date. Bad Excel.

Does anyone happen to know if there is a token I can add to my csv for this field so Excel doesn't try to convert it?

I'm trying to write a csv file from my application and one of the values happens to look enough like a date that Excel is automatically converting it from text to a date. I've tried putting all of my text fields (including the one that looks like a date) within double quotes, but that has no effect.

Stop Excel from automatically converting certain text values to dates

Does anyone happen to know if there is a token I can add to my csv for a certain field so Excel doesn't try to convert it to a date?

I'm trying to write a .csv file from my application and one of the values happens to look enough like a date that Excel is automatically converting it from text to a date. I've tried putting all of my text fields (including the one that looks like a date) within double quotes, but that has no effect.

Source Link
user16324
user16324

CSV file. Excel is automatically converting my text to a date. Bad Excel.

Does anyone happen to know if there is a token I can add to my csv for this field so Excel doesn't try to convert it?

I'm trying to write a csv file from my application and one of the values happens to look enough like a date that Excel is automatically converting it from text to a date. I've tried putting all of my text fields (including the one that looks like a date) within double quotes, but that has no effect.