Change die column format for an tab delimited export | Community
Skip to main content
New Participant
June 16, 2020
Solved

Change die column format for an tab delimited export

  • June 16, 2020
  • 1 reply
  • 1324 views

At the moment we download our list in the format  tab delimited. Afterwards we import that list into excel and have to change the format of the column with phonenumbers from number to text. 

 

Is there a way that we can change the column format already in Marketo. 

 

Thanks for your help

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

It's Excel that's choosing the datatype, not Marketo.

 

There's no way to format the number in such a way that it would still look right in the Marketo UI but be shown in Excel as text. That is, you can add a "=" at the beginning of the Phone which Excel appears to interpret (and remove) — but then the Phone looks very wrong in Mkto.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
June 16, 2020

It's Excel that's choosing the datatype, not Marketo.

 

There's no way to format the number in such a way that it would still look right in the Marketo UI but be shown in Excel as text. That is, you can add a "=" at the beginning of the Phone which Excel appears to interpret (and remove) — but then the Phone looks very wrong in Mkto.