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...
In that case, if I have 9 numbers, I need to change the formula to =A1+60000000000(remove 1 "0").
