Excel export show date instead of money value

Hi there @Iztok,

Thanks for sharing with the Community.

That is interesting behavior. Do you mind sharing an example of what appears vs what should be returned from your segment exports? Is it possible that your CSV has an incorrect format or mislabelled column that is causing this issue? 

Looking forward to hearing back,

Alex
 

Hi, Alex,

I just realized that when I rearange exported data (from one column) to various columns some of the ones that contain money values are turned into dates.

Not all of them, mind you.

So this:

| iztok.golob@gmail.com,12.75,26.11,12.75, |

becomes

iztok.golob@gmail.com | dec.75 | 26.nov | dec.75, 

It loks like it only happens with values from 1 - 12 (months). 

Do i need to format differently the original exported column first, before I spread it to various columns?

I looks like it is the excell issue. Not Klaviyo. But I would appreciate help regardless :).

Iztok

Hi @Iztok,

Thanks for the response with the example.

You’re correct that this is something going on within Excel’s side of the data importing.

Formatting the columns before moving them around would be helpful! This is of course assuming you’re manipulating data here and moving things around before/after. I would also suspect depending on the format of the column you set up, the column you are moving it in might be causing the issue as well.

One solution I think you can try is after exporting the data (before manipulation), copy and paste the data without formatting into a new sheet. Doing so would ensure that the entire sheet has 0 formatting so manipulating the data wouldn't cause any issues.

Hope this helped!
Alex

Hi, I think I figured it out. Thanks to you mentioning formating. What I did in the wizzard was setting each column from the “general” to “text” before finishing rearranging.

Hope all this makes sense. I use excell in my native language and I haven’t got a clue how all these excell options and funcionalities are called in English.

Thanks for you help. You did a lot.

Iztok