how do I format decimals
 

=1375850/100, formatted as a decimal w/two places, or, equivalently in code

Range("A1").Value = format(1375850/100, "#.00")


"ciscopena" wrote in message
...
I'm having a problem with formatting decimals. The number is 1375850. I'm
trying to get 13,758.50. When I try to format the decimal I get
1,375,850.00.
I have about 1500 number that I have to format. I know how to do manually,
but it takes to long. I'm currently using excel 97. If anyone knows how to
do
this I will greatly appreciated.