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
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,133 Most Valuable Professional
nmaenpaa 101,154