Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to convert Excel imported numbers from text to numbers?

April 26, 2017convert Excel imported Numbers text

0

Posted

How to convert Excel imported numbers from text to numbers?

1 Answer

0

Posted

We have a software package from which we can export data to MS Excel. However, when exported it arrives in Excel as text. Even though they are numbers, they act like text. The only way to convert them text to numbers is to edit the cell (press F2) and hit enter. I’ve tried every other method of copying and pasting (even pasting special), but nothing seems to work.