Question

Unable to input values starting with 0 into Excel file or CSV file

  • 10 March 2022
  • 3 replies
  • 10 views

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?


3 replies

Userlevel 3
Badge +7

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 3
Badge +7

You're welcome

Reply