So, to fix the random numbers you generated (I used the RAND function in my example below), select the cells containing those ...

You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.

Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.

If the Excel cell format is not changing to a number because the Number formatting is not working, take these steps to fix the issue.