Hi team, The number 0 keeps getting truncated when trying to work with the number starting with 0. I tried to use text format in the input excel file, but the issue still persisted. Can anyone help with this? Here is the screenshot for your visibility. [image (25)]

Hi, [image] Sisay_Dinku: modern design How about to use FormatCell in advance, as the following? Please also check the following sample. [image] Sample20221129-3.zip (11.2 KB) Regards,

How to solve: 0 (zero) gets truncated with the number beginning with 0 in my output excel file

Help Studio

Sisay_Dinku (Sisay YDG) November 29, 2022, 3:20am 4

@sangeethaneelavannan1 thank you. I forgot to mention but not all numbers begin with zero (0), some are just natural numbers like 92145 (five digit)

1 Like

Topic		Replies	Views
Number with leading 0 is getting Truncated in Excel Activities excel , activities , question	5	3531	March 4, 2021
0 truncated in excel Studio studio , question , activities_panel	6	1911	December 9, 2021
Excel related Studio studio	5	340	August 8, 2023
Problem with writing in excel Help studio	5	1698	May 3, 2018
How to split 1 from 0001 Studio datatable , excel , activities , question	8	1080	November 21, 2021

How to solve: 0 (zero) gets truncated with the number beginning with 0 in my output excel file

Related topics