FormatNumber

[adimulam]

Hi,
I am using Excel Spread sheet in my program. I want to format a numberic value in a paricular cell in such a way that the mumeric value has 2 digits after decimal (Ex 0.1 should come as 0.10). I tried "Wsheet.Cells(18, 18).FormatNumber = 2". It did not work. Any ideas?

Thanks,
Adimulam

 

[coolcarls]

Hi,
Now I am the newest of newbees and shouldn't even try to answer these questions, and I'm sure that I am missing the point but I couldn't resist...Apoligies in advance

Why don't you use the format button and select cells then the numbers tab and choose number and then select decimal places 2?

 

[adimulam]

I need to control everything through VB. I do not want to physically open the document and format it.

Thaks,
Adimulam

 

[adimulam]

I need to format the cell through VB program. I do not want to open the document physically and format the cell.

Thanks,
Srini

 

[bryanbayfield]

Wsheet.Cells(18, 18).NumberFormat = "0.00"

I'm assuming here that you have defined an object called

Wsheet

which refers to the worksheet you wish to format?

 

[adimulam]

I found the answer myself. Wsheet.Cells(18, 18).Numberformat = "##0.00"

Thanks,
Adimulam