I've tried every FORMAT idea I can muster. I've got a column of numbers with
either 0, 1 or 2 numbers to the right of the decimal. I need to consistanly
have 2 decimals.

Format, cells, number
then choose number of decimal places, and whether you want thousands separator

Format, cells, custom
0.00
#.00
#,###.00

More information on formatting can be found in several places within
http://www.mvps.org/dmcritchie/excel/formula.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dirtbike" <(E-Mail Removed)> wrote in message news:1BD6A2E7-4791-4F96-B520-(E-Mail Removed)...
> I've tried every FORMAT idea I can muster. I've got a column of numbers with
> either 0, 1 or 2 numbers to the right of the decimal. I need to consistanly
> have 2 decimals.