I have mixed data in my Excel sheet containing both text and numbers(in text format). How can I convert only numbers into (number format)?
Choose column you want to convert and then Data -> Text to Columns
In freshly opened Wizard choose Delimited -> Next -> Choose Delimiter Tab -> Next -> Choose General -> Finish
Repeat steps for both columns if needed. Result:
Also this question is more suitable for Superuser site