Skip to main content

Notifications

Microsoft Dynamics RMS forum

exporting data??

Posted on by Microsoft Employee

Can I export my inventory list from RMS to excel and not have the numbers change?  I lose the leading zero(s).  

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: exporting data??

    One way is to export to a .csv file, open the file using Notepad or some other text editor, copy/paste the data into Excel, then use the Text to Columns feature using Delimited as the data type and Comma as a delimiter and then set any columns containing data with leading zeros to Text.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: exporting data??

     This is a problem with Excel.   You need to set the column to Text format or use a custom format to allow leading digits.  

    office.microsoft.com/.../keep-leading-zeros-in-number-codes-HA010342581.aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,133 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans