Skip to main content

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?

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​ 

You're welcome

Reply


Terms & ConditionsCookie settings