Announcements
No record found.
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
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
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.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
