When you download data from some back-office system or a CRM system, numbers in the sheet may appear like like text. They are right-aligned and sometimes also have an error mark as shown in the image below.
Paste Special’s Multiply feature is to be used to convert all the textual numbers to normal number format in 1 shot.
To convert these textual numbers to a normal number format, Paste special’s Multiply feature comes in handy.
- Write 1 in a cell, any cell.
- Copy that 1.
- Select all the textual numbers.
- Right-click and go to Paste Special.
- Select Multiply and press Ok.
What it does
Simply multiplies all the numbers by 1, essentially keeping the numbers as it is, but changes their format to a normal number format immediately.
So do not go changing each number one by one, use this simple method and you’re done!