How to copy a number as it is from Excel to Template.

[Gaurav0001]

Hello,
I need to copy number as it is from excel to template.
For Example,
I need to copy number "03032024" to template.
and its coming 3032024 as output.

As the number indicates the Date, If "0" get  removes from the beginning, it will change the whole date and make us fall in confusion.
I dont want date as 03-03-2024 format or 03/03/2024, 
It will be great if I get in String Datatype. "03032024"

Thank You.

[mgaronson · Accepted solution]

The Date field in Excel is likely formatted as a Text field (not sure how else it would work without some funky formulas). If the field is formatted in Excel as a Text field, it should come into to Alteryx as a String. Even if one value is formatted as a number (A4), it will come is as String.

Text type

 Text and Number

 

Alteryx

  If the whole column looks like a number (ex: Date 2 - 12012024, 12022024, 12032024) and is General or Number type field in Excel, Alteryx will type as a double.

Alteryx

 

 

[Gaurav0001]

Thank You @MG ,
This Helps, I have understood what needs to be done. :)