Need macro advice! Saving longer numbers as strings to show all the characters

Our take

Are you struggling with Excel automatically reformatting long numerical data, such as FedEx tracking numbers, into scientific notation? This common issue can disrupt your output files, particularly when dealing with strings of varying lengths, often under 20 characters. If you're using a macro to generate new files, consider updating it to convert these numbers into strings, ensuring all characters are displayed correctly. Even simple solutions, like adding a hidden character before data transfer, can help maintain the integrity of your output.

Desktop, Excel 365 Build 19929.20106 Click-to-Run, Beginner

We have a macro that generates new files using a list of data. Sometimes that data is completely numerical with over 15 digits. Excel keeps reformatting these numerical entries using scientific notation, which screws up the output files.

Right now I have to manually check the output files and reformat the affected ones so that all then hidden characters are shown.

Can someone please advise on how I can update the macro to automatically convert these numbers into strings that show all the characters? The data is of variable length, but I'm pretty sure it's always under 20 characters.

This problem only affects one cell of the output file. Everything else is generated without issue.

It's basically the problem of "how do I make Excel macro copy-paste the entire FedEx tracking number correctly" but the data isn't consistently 16 characters and is frequently alphanumeric.

EDIT: I'm open to even stupid and booleg solutions like "add a hidden text character before transferring the data" to force this to work. The output files are basically just printables. I just don't know anything about macros and do not have time to learn.

submitted by /u/Umklopp
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#real-time data collaboration#data cleaning solutions#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#Excel compatibility#Excel alternatives#rows.com#enterprise-level spreadsheet solutions#AI-driven spreadsheet solutions#financial modeling with spreadsheets#no-code spreadsheet solutions#real-time collaboration#macro