1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Excel formatting things like "2-2" as date, then when reformatting to text it inserts a random number

We have a user exporting information from a software to an excel sheet. One of the columns contains numbers like "2-2" "4-3" and so on. These are not dates, they are election precincts. They need to stay as they are.

When exported into excel, they are automatically converted into a date format. This wouldn't be a huge issue if I could reformat them into text properly.

If I try to change the format to text, or number, or anything else, it inserts seemingly random numbers. So it takes "2-2" and turns it into "02/02/2026" and then when formatting that as text, turns it into something like "46116"

Can I disable automatic formatting somehow? Or at least just have a way to format it back to it's properly original content?

Edit: We cannot type this information. Adding an apostrophe isn't a viable option because it's an exported dataset of thousands of entries.

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#digital transformation in spreadsheet software
#large dataset processing
#Excel
#formatting
#election precincts
#date format
#automatic formatting
#exporting
#text format
#original content
#numbers
#dataset
#exported information
#text
#reformatting
#format