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?

All responses (3)

Answers (1)

Suggested answer

Marco Mels on at

Like (0)

Report

RE: business central reading excel codes in right format

Thank you for sharing the final solution.
Verified answer

samerabd 70 on at

Like (0)

Report

RE: business central reading excel codes in right format

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

Marco Mels on at

Like (0)

Report

RE: business central reading excel codes in right format

Hello,

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

Thanks.