Feedback by UserVoice

How can we improve Excel for Mac?

Provide way to avoid automagical field value reformatting when opening CSV files

Theis is related to the leading zeroes one, but it is at least as bothersome that it tries to format as an excel data anything that looks like a date -- including values that are not dates. And the date formatting means you can't use Excel to open a CSV with dates, edit it, and re-save it without completely changing the way dates are formatted.

55 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Matt shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    This would be a huge improvement. Excel is used often to analyze phone system call detail records. Phone numbers and dialed digits often are very long which are converted to scientific notation or begin with a leading + or leading 0 (which are dropped).

  • Joe Park commented  ·   ·  Flag as inappropriate

    Additionally, please include an option to prevent autoformatting of numerical string values in CSV files to scientific notation. In practice this behavior appears to automatically drop numbers beyond the 6th significant digit upon saving and has wreaked havoc on the work of many unsuspecting users in our office.

Feedback and Knowledge Base