PDA

View Full Version : Editing decimals :)



M0ng00se
01-15-2008, 06:18 PM
Okay, how would i go through a column and look at every value, and for all the numbers that are whole numbers, add a .00 at the end, and for all the numbers such as 200.5, add a single 0 to the end.

So, i pretty much want it to...

Change 100 to 100.00
and
100.5 to 100.50

Anyone have an idea? :P
Thanks in advance
-Ryan

mikerickson
01-15-2008, 06:38 PM
Format the cells to show two places. Set the Format to "#.00" (no quotes)