Standard Excel import not recognizing decimal point and trailing zeros when Insert decimal a point when missing is checked



Description of Issue

I am trying to import two entries for the amount of $190.00 each. When importing, EERP powered by Munis will save the import as $1.90. Insert a decimal point when missing is checked



Context

Import Journals

Standard Excel Imports



Cause

The data type for the cells with the amounts are set to Number instead of the Text data type. The decimal and trailing zeros are not recognized when set to the Number data type. 



Resolution

Change the data type to Text and re-enter the decimal and trailing digits to the amounts. 



Additional Information