Stop Excel from automatically converting certain text values to dates

0 votes
Does anyone know whether I can add a token to my CSV for a certain field to prevent Excel from trying to convert it to a date?

When I try to export an a.csv file from my application, Excel turns one of the entries into a date by default because it closely resembles one. I've tried enclosing all of my text fields in double quotes, including the one that resembles a date, but that had no impact.
Dec 28, 2022 in Others by Kithuzzz
• 38,010 points
327 views

1 answer to this question.

0 votes
I've discovered that getting the desired result requires adding a "=" before the double quotes. It requires only text for the data.
answered Dec 29, 2022 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer

Excel formula to replace or stubstitute only text that starts with a certain letter

You're requesting a "formula." Normally, you would ...READ MORE

answered Nov 21, 2022 in Others by narikkadan
• 63,420 points
261 views
0 votes
1 answer

Stop power query from loading to excel sheet

You can just delete the worksheets created ...READ MORE

answered Dec 17, 2022 in Others by narikkadan
• 63,420 points
3,833 views
0 votes
1 answer

Filter/Extract a text from excel sheet having similar values

ISNUMBER(SEARCH("Maria,",SUBSTITUTE(A1:A4,"]",",")))  shows TRUE if Maria is found and false if it would ...READ MORE

answered Jan 9, 2023 in Others by narikkadan
• 63,420 points
189 views
0 votes
1 answer

Excel Function to Exclude rows based on certain values

One method is to combine the FILTER() ...READ MORE

answered Jan 23, 2023 in Others by narikkadan
• 63,420 points
6,082 views
0 votes
1 answer

How can I import an Excel file into SQL Server?

You can use OPENROWSET to import an Excel file ...READ MORE

answered Sep 15, 2022 in Database by narikkadan
• 63,420 points
1,605 views
0 votes
1 answer

Excel convert multiple columns to dataset based on unique timestamp

F2 =UNIQUE($B$2:$B$20) G2 =FILTER($C$2:$C$20;($B$2:$B$20=$F2)*($A ...READ MORE

answered Jan 17, 2023 in Others by narikkadan
• 63,420 points
317 views
+2 votes
1 answer
0 votes
0 answers

How to save the import csv file to mongodb using pyspark (or python)?

I have this code, and I want ...READ MORE

Oct 9, 2019 in Python by Ahmed
• 310 points
2,101 views
0 votes
1 answer

Excel automatically converting 7 digit CAS number to another number (date?)

Looks like you could use: The formula in D2: =SUBSTITUTE(F ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,420 points
619 views
0 votes
1 answer

How to automatically nest rows of an Excel spreadsheet using level values?

More grouping levels have been added to ...READ MORE

answered Nov 21, 2022 in Others by narikkadan
• 63,420 points
475 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP