How to fix excel formatting issues.

Disclaimer: These screenshots are from Microsoft® Excel® for Microsoft 365 MSO (Version 2112 Build 16.0.14729.20254) 64-bit

This article is to address any issues with excel changing the modify assets or users DMU spreadsheets data when first opening the spreadsheet.

1. Download the modify asset/users spreadsheet from the Data Management Utilty.
2. Open a blank excel spreadsheet.
3. Select the data tab.
4. Click on Get data from txt/csv.
5. 
6. Import the CSV file.
7. Select "Do not detect data types" and then click load.
8. Copy the data to your modify asset/users spreadsheet.
9. Save as a CSV file.

Attachments (1)

69a6899d3ee8d.9608161996691.png
41.5 KB