File format vs Anaplan

Tin
Tin
in Modeling

Hi,

I want to ask for help with why while importing, it keeps on reading my code like this xxxxx+12?

Attached photos for reference:

File: (.csv format)

image.png

Anaplan:

image.png

Thanks,

Thank you.

Tin

Tagged:

Answers

  • Dikshant
    Dikshant

    In Excel, it autoformat it to this format 4.0201E+12

    image.png

    Change the format to Number in Excel and reupload the csv file in Anaplan.

    image.png

    It will load it in the correct format. Try it out.

  • MarkWarren
    MarkWarren

    @MC This is just how Anaplan represents the number in the preview, the underlying number is not affected.

Categories