I’m trying to print a number into excel that starts with zeros, something 000123,
the solution I had in mind is that concatenate the number with a single quote, something like SampleInteger + “’”, but when I check the excel file. it displays 123 and no single quote was printed in the cell. How do I achieve this?
the result I’m trying to achieve:
Hi @wdescalsota ,
Could you try this and see if it works out for you?
(From row In dt_sampleData.AsEnumerable()
Let ls = row.ItemArray.ToList()
Let ra = ls.ConvertAll(Function(a) "'"+a.ToString).ToArray()
ExcelUnTruncate.xaml (8.5 KB)
sorry, currently having issues with my Generate DataTable from Text activity which is having excess rows which is a duplicate of the first row. I’ll get back to you as soon as I fix this and able to test the solution you provided. Thank you for the response, BRB
try this :
By saving the variable as string.
Uploading: Screenshot (114).png…
the single quote trick helps to keep the leading zeros
filling up the number we can do with following:
Also try this :
D2-> digits you required.