•1 min read•from 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
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.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#Excel
#pivot table
#imported data
#data formatting
#numbers
#quickly convert
#data analysis
#cell value
#data type
#text
#spreadsheet
#Excel functions