Forum Discussion
Excel number formats
You can do the following:
Enter 1000 in an empty cell.
Copy this cell (Ctrl+C).
If you want to multiply some cells with 1000, select those cells.
Right-click in the selection and select Paste Special... from the context menu.
Under Operation, select Multiply, then click OK.
Or if you want to divide some cells by 1000, select those cells.
Right-click in the selection and select Paste Special... from the context menu.
Under Operation, select Divide, then click OK.
You can then clear the cell in which you entered 1000.
Thanks Hans!
You can do the following:
Enter 1000 in an empty cell.
Copy this cell (Ctrl+C).
If you want to multiply some cells with 1000, select those cells.
Right-click in the selection and select Paste Special... from the context menu.
Under Operation, select Multiply, then click OK.
Or if you want to divide some cells by 1000, select those cells.
Right-click in the selection and select Paste Special... from the context menu.
Under Operation, select Divide, then click OK.
You can then clear the cell in which you entered 1000.
- Thanks Hans,
That's fixed the issue, thanks for your time 🙂