Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a csv file that contains cells such as "+1.8882789780". When viewed in Excel, it loses the last digit possibly due to excel truncation.

Is there a way to either change the setting in Excel to prevent this from happening or change the csv file in some way?

One way is to wrap single quotes around the cell contents in addition to the double quotes.


Is there a better way?

share|improve this question
See: – Excellll Sep 23 '12 at 14:52

Precede the quoted string with an = sign, e.g., ="+1.8882789780".

share|improve this answer
Note that if you're using Excel 2007, it has a bug that might require a workaround (depending on the quoted text). Read this thread for details. – Karan Sep 22 '12 at 22:53
is there a way without changing the actual content? like modifying excel settings? – user15586 Sep 22 '12 at 23:30
Yes. You can also select the cells of interest, right-click and select Format Cells ..., then select Text. But you'll need to do that before entering the value. Once it's been interpreted as a numeric value, the extra digits will have been lost. – Nicole Hamilton Sep 22 '12 at 23:38
Addition to the comment just above: remember that Excel can't save formatting information in csv file – Serge Sep 23 '12 at 1:39
@Serge, true, but cells formatted as Text will be saved exactly as entered and displayed. – Excellll Sep 24 '12 at 0:16

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .