Imported a GL acct number with dashes

SOLVED

I am having a tough time importing GL account number for an asset update. My account numbers are 620-01-01 for example and no matter what I do to the import file, it imports them as 01/01/0620. Here's what I've tried:

1. In .csv formatted column to General and also tried this as an excel file too.

2. Opened in notepad, save as a .txt and then opened in excel and made sure formatting on column was general.

3. Put a ' in front of account number.

4. Did a custom format on column to be ###-##-## and also tried 000-00-00.

Top Replies

Parents Reply Children
No Data