FG
💻 Software

Open CSV file in Excel having leading dash

Fresh5 days ago
Mar 15, 20266601 views
Confidence Score0%
0%

Problem

I have a csv file which looks like this : I think this form is valid, isn't ? When I open the file in Excel, the "-arm" is parsed by Excel as a formula. How can I force Excel to read the value as plain text ? If required, I can change the CSV format. PS: don't ask me to add a leading . I don't want…

Error Output

Ref;Code;OtherData;
"MyRef";"-arm";"something";

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Open CSV file in Excel having leading dash

Low Risk

What you need to do is import the csv into excel as "text" so go to (2010) and select the csv file. The import wizard will allow you to select columns and treat them with specific formats, any column with a dash or plus can be treated as text and it…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment