Excel imported column need to be formatted

Dynamics 365 Business Central/NAV User Forum
1

Dear all,

I have a set of data to be imported from EXcel.Column DataType is Code.Some of My data contains Numerics only and some mixed with text and digits.My problem is, the data with digits displayed with Comma(like Number representation in Excel).Is there any format function i can use to format my column so that i can see the data as Text fomat. I tried Numberformat but no effect. Please help me…!!!

Thanks & Regards

Rose

2

Format the Excel column as text before saving as CSV and importing?

3

Rose,

One addition - be careful with Code fields - make them all uppercase before importing! Sometimes its physically possible to import some lowercase letters in Code fields, but it is NOT allowed by Navision rules.

4

Thanks a lot Adam. But isn’t any similar function like Numberformat to do the formatting from Navision itself??

Please help

Thanks & Regards

Rose

5

Hi Rose,

Then you must use the Excel automation instead of CSV files.

6

Hi Erik,

Could you please explain me in detail…[:D] I need it urgently[:O]

Thanks & regards

Rose

7

Hi,

I am using the Excel Automation itself. But after importing the data from Excel , in Navsion its not showing zeros in my data and if i use format function then code with numeric data will show as integers .ie 123,456 etc. Is there any solution for this?

Thanks & Regards

Rose