File format vs Anaplan

Tin

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)

Anaplan:

Thanks,

Dikshant

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

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

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

MarkWarren

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