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

How to have excel read these numbers as such instead of text

https://preview.redd.it/d3ulsqq404kg1.png?width=1130&format=png&auto=webp&s=acb558d40559057504e8e7f36d2ab0b4aa3e4dc9

I have imported data from a website, but it's reading it as text instead of a number. When I double click and press enter it actually turns into a number, but I need to quickly turn them all into numbers instead of going one by one in order to make a pivot table.

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

Want to read more?

Check out the full article on the original site

View original article