Share
ReportCan 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
You’re offline. This is a read only version of the page.
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.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (