Forum Discussion
Copy formula result as number
Assume that I have 10 numbers (1234567890) to add "60" in front of it, so I custom a new cell format of "600000000000". Yes I did get the result I wanted (601234567890). But I wanted to copy the res...
DennisNg98 Indeed, you merely formatted the number 1234567890 to be displayed as 601234567890.
But the underlying number hasn't changed. If the number is in A1, why not just add a formula in B1 like:
=A1 + 600000000000
That will result in a real number, though might have to set the format to Number as well, otherwise you'll probably get this:
- In that case, if I have 9 numbers, I need to change the formula to =A1+60000000000(remove 1 "0").
