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

Question

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 Answer

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