Need to Drop Decimal but keep ending zeros

tcnt9176

Board Regular
Joined
Jun 23, 2008
Messages
223
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

Legend
Joined
Feb 18, 2002
Messages
13,690
Ho does Find/Replace not work? It did for me on your example data.
lenze
 

tcnt9176

Board Regular
Joined
Jun 23, 2008
Messages
223
i also have an issue with 0.50 showing in the formula bar as .5 instead of 0.50
 

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
It didn't for me! How are you doing it?
Find: "what" ??
Replace with: "what" ??
lenze
 

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Just use
Find "."
Replace (Nothing) No entry in field at all
lenze
 

tcnt9176

Board Regular
Joined
Jun 23, 2008
Messages
223
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

Board Regular
Joined
Jun 23, 2008
Messages
223
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
 

Forum statistics

Threads
1,082,630
Messages
5,366,656
Members
400,909
Latest member
ola97316

Some videos you may like

This Week's Hot Topics

Top