Need to Drop Decimal but keep ending zeros

[tcnt9176]

Here's my problem. I need a formula to take the decimals out of a column but keep ending zeros. I have tried find/replace & several formulas but nothing seems to be working. Here is an example of the numbers in the column and the end result I need. Thanks!!!

9.66 966
0.50 050
13.09 1309
309.98 30998

 

[lenze]

Ho does Find/Replace not work? It did for me on your example data.
lenze

 

[tcnt9176]

it changed 0.50 to 5.00

 

[tcnt9176]

i also have an issue with 0.50 showing in the formula bar as .5 instead of 0.50

 

[lenze]

It didn't for me! How are you doing it?
Find: "what" ??
Replace with: "what" ??
lenze

 

[tcnt9176]

find "." (decimal) replace with "" (blank)

 

[lenze]

Just use
Find "."
Replace (Nothing) No entry in field at all
lenze

 

[tcnt9176]

sorry. that's what I meant by blank. I didn't put anything in it. How is your formatting in the columns you are using?

 

[tcnt9176]

ok. I played around with it and with much fun. I was able to convert it by separating #s over .99 and converting them separately. My only remaining issue is that these #s all need to be 10 digits long with leading zeros to fill in the blank digits. I know how to format to get that but I need it to actually be a part of the #.

5656 0000005656
76543 0000076543

 

[tcnt9176]

got it to work with =RIGHT("0000000000"&A1,10) . thanks.