On import, .xls and .xlsx files will add '.0' to any numerical value

  • 5
  • Problem
  • Updated 6 years ago
  • Solved
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: Resolved

Copied from this topic.

"Katie, one little thing I'm having trouble with. I made the new field numeric (seemed reasonable for a dollar amount). But it keeps adding .0 (or .2, etc.) at the end of the numbers. I have tried making my import data text, but it continues to do it. What am I doing wrong?"
Photo of Katie Lewis

Katie Lewis, Official Rep

  • 3414 Posts
  • 309 Reply Likes

Posted 6 years ago

  • 5
Photo of Katie Lewis

Katie Lewis, Official Rep

  • 3414 Posts
  • 309 Reply Likes
I'm sorry for this trouble! There's a bug in our platform right now where .xls and .xlsx files will add '.0' to any numerical value when imported.

It looks as though you imported an .xls file. Try saving your file as .csv instead and importing this version -- It should do the trick.
Photo of Life in the Tetons

Life in the Tetons

  • 3 Posts
  • 0 Reply Likes
I Love you KATIE!!!! Thank you!! Worked like a charm.
Photo of Katie Lewis

Katie Lewis, Official Rep

  • 3414 Posts
  • 309 Reply Likes
Terrific!
Photo of Life in the Tetons

Life in the Tetons

  • 3 Posts
  • 0 Reply Likes
This reply was created from a merged topic originally titled
Importing Format errors.


I have created a new number field for managing some of my contacts and every time I complete the import a decimal (.0) is added to the end. How do I stop this from happening?
Photo of Lighthouse Writers

Lighthouse Writers

  • 10 Posts
  • 1 Reply Like
This reply was created from a merged topic originally titled
how can I change or eliminate the decimal point from numeric fields.


I'm using custom fields for suggested donations, uploaded from a spreadsheet. No matter what the format is in the spreadsheet, text, numeric, it is entered in myemma as X.0. I need to insert this with a $ and either no decimals or two.
Photo of Katie Herzig

Katie Herzig

  • 3 Posts
  • 0 Reply Likes
Hey guys, this is still happening. Saving as a CSV isn't working, it's saying "There seems to be something wrong with the formatting of your file." There isn't anything wrong with it, we've made very sure of that.
Photo of Katie Lewis

Katie Lewis, Official Rep

  • 3414 Posts
  • 309 Reply Likes
Hi Katie! I spotted that you also posted in this conversation, so I’ll answer you there.
Photo of Katie Lewis

Katie Lewis, Official Rep

  • 3414 Posts
  • 309 Reply Likes
This bug has been fixed!