cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Skilled Sharer
Skilled Sharer

Export SharePoint to Excel - Leading zeros removed from single line of text column

Hello, I am exporting a SharePoint single line of text field to excel and unfortunately the leading zeros are being removed in excel e.g.

0020 becomes 20.

Wondering if anyone knows how to prevent this from occurring.  Thank you.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Skilled Sharer
Skilled Sharer

Re: Export SharePoint to Excel - Leading zeros removed from single line of text column

Hi, sorry worked this out...  change excel column from General to Text !

View solution in original post

1 REPLY 1
Highlighted
Skilled Sharer
Skilled Sharer

Re: Export SharePoint to Excel - Leading zeros removed from single line of text column

Hi, sorry worked this out...  change excel column from General to Text !

View solution in original post

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (8,605)