Unanswered

Importing to Excel - Excel removes leading zeroes

Like (1) Share

Report

Posted on 4 Jul 2024 04:58:32 by Kanishkyash222

Hey there,

When I am importing the data from powerapp to csv file via automate flow. The excel removes the leading zeroes automatically.

For eg: I have a column with values like - 0012, 000233, 0213. After importing it becomes 12, 233, 213 in excel which I don't want. Is there a way to avoid removing of leading zeroes?

Categories:

Business Process Flows

All responses (3)

Answers (0)

Kanishkyash222 on 08 Jul 2024 at 12:24:26

Like (1)

Report

Re: Importing to Excel - Excel removes leading zeroes

@FLMike Any response?
Kanishkyash222 on 04 Jul 2024 at 06:21:20

Like (1)

Report

Re: Importing to Excel - Excel removes leading zeroes

Hey @FLMike , Can you please elaborate on How Can I create a custom format Column in Excel, Because I am using "Create CSV" action in power automate to create a csv file.
Michael E. Gernaey 42,080 Super User 2025 Season 1 on 04 Jul 2024 at 05:56:38

Like (1)

Report

Re: Importing to Excel - Excel removes leading zeroes

Hi @Kanishkyash222

Make it a string column in Excel

that or create a Custom format IN excel on that column.

Take a look at the Custom ones built in, modify it, or create a new one like those.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey