Forum Discussion

Songbirdterry23's avatar
Songbirdterry23
Copper Contributor
Sep 28, 2023

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.

Resources