- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-11-2014 03:48 PM
When importing an excel file with a column of type "Currency", some of the records get the wrong value for the field.
For example, if the value "14295374.53" in the excel file becomes 1.43 in the table.
Solved! Go to Solution.
- Labels:
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-11-2014 03:48 PM
Currency fields are imported as decimal which can cause large Currency values to get corrupted as you can see in your example.
To resolve this issue you can simply perform one of these two actions:
- Change the column type in Excel spread sheet from Currency to Number
- Go to the loaded table and set the field from Decimal to String 40
#2 is the better way, as you will only need to do this once and not worry about changing future files
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-11-2014 03:48 PM
Currency fields are imported as decimal which can cause large Currency values to get corrupted as you can see in your example.
To resolve this issue you can simply perform one of these two actions:
- Change the column type in Excel spread sheet from Currency to Number
- Go to the loaded table and set the field from Decimal to String 40
#2 is the better way, as you will only need to do this once and not worry about changing future files