Try:

Format Cells... Number Custom and in place of general type 0
--
Gary's Student


"kmuralishankar" wrote:

Hi all,

I generated a report in which i get the numbers with a decimal point. EX:
12345.0 where I am supposed to get as 12345, changed the decimal settings to
zero and still no effect. I tried the default number places as zero under
options still no effect. Under format cell, Customer been kept as general.

Excel 2003 version, OS: XP.

Please someone help me in this issue as it is taking long time to format
this report for me.

Thanks
Murali