For example, using a string variable, I wanted to input '01032019' into the Excel worksheet. But only '1032019' is recorded.
How do I record values starting with 0 into Excel or CSV file?
Userlevel 6
+15
Hi @Prancia Toh,
You can fix this by using the excel format cell options,
https://www.enterprisetimes.co.uk/2018/05/18/typing-numbers-that-start-with-a-zero-in-excel//p>
Thanks @Tamil Arasu
Userlevel 6
+15
You're welcome
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.