Skip to main content
Question

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

  • March 10, 2022
  • 3 replies
  • 66 views
P

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
    Forum|alt.badge.img+18
    • 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_1
    • Author
    • March 11, 2022

    Thanks @Tamil Arasu​ 

    Tamil Arasu10
    Most Valuable Pathfinder
    Forum|alt.badge.img+18
    • Tamil Arasu10Most Valuable Pathfinder
    • Most Valuable Pathfinder
    • March 11, 2022

    You're welcome

    _Tamil_
    Terms & ConditionsCookie settingsAccessibility statement