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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.