Skip to main content
P
Pra_1
March 10, 2022
Question

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

  • March 10, 2022
  • 3 replies
  • 112 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

    Tamil Arasu10
    Most Valuable Pathfinder
    Tamil Arasu10Most Valuable Pathfinder
    Most Valuable Pathfinder
    March 10, 2022

    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>

    _Tamil_
    P
    Pra_1Author
    March 11, 2022

    Thanks @Tamil Arasu​ 

    Tamil Arasu10
    Most Valuable Pathfinder
    Tamil Arasu10Most Valuable Pathfinder
    Most Valuable Pathfinder
    March 11, 2022

    You're welcome

    _Tamil_
    Terms & ConditionsAccessibility statement