Error when importing budget - "You cannot enter ' - ' in Decimal"

Business Central/NAV User Forum
1

Hi.

Can someone please assist me with addressing the following error message:

“You cannot enter ’ - ’ in Decimal”

This occurs upon import of my Budget template from the Budget module in NAV 2013.

Thank you,

Dan

2

I figured out the issue.

Please disregard this post.

Thank you,

3

Please share your solution with us so that it can help others in future.

4

I discovered the error myself after reviewing the spreadsheet and noticing that there were 3 cells with " - " in them that were brought over (likely as type TEXT) when copying figures from another Excel Worksheet.

Once I deleted these 3 cells (because the amounts in them should have been zero) and re-imported, the import worked very well.

Regards,

Dan