business central reading excel codes in right format

(0) Share

Report

Posted on by samerabd

i'm Importing an excel file using xmlport but there is a column where it's written 8.72E+12 which is =8720000000000 but it take the code not the number, how can i fix this?

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

In what type of field are you trying to import the value into?

Thanks.

Was this reply helpful? Yes No
Verified answer

samerabd 70 on at

Like (0)

Report
Copy link

Link copied!

Problem Solved it was Excel File Format Problem it was changed to Number

Was this reply helpful? Yes No
Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you for sharing the final solution.

Was this reply helpful? Yes No