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 for your reply Hans. The file did use the comma as the separator originally but i rectified this by changing the ',' to '.' in the options, advanced section. I thought that perhaps this would solve my issue but it hasn't so far.
What happens if you recalculate the formula, for example by pressing F2 in its cell, then pressing Enter?
- The same result unfortunately. If I enter the value in the cell instead of the cell reference the number is correct though. Is there anyway I can replicate this in a formula?
Thanks again for your time.Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
- https://docs.google.com/spreadsheets/d/176bM9BFE7eixLatGgg85wjxF7IKTABLx/edit?usp=sharing&ouid=111952071670621667207&rtpof=true&sd=true
Hi Hans,
Please see attached. Should be open for editing. under 'new' i need the values to have decimals after the first digit, not fourth.
Best,
Alfie