Forum Discussion
Replace a decimal number with the number 1 in a spreadsheet
I have a large worksheet. one column has numbers like this: 0.00 4045197931 How can I delete the "0.00" and replace it with the number "1"? it needs to read: 14045197931.
=REPLACE(A1,1,5,"1")You can try REPLACE if the values always start with a 0.00 pattern.