Format of Number

[drunkenneo]

Hi,

I am fetching data from the ADO connection to my excel cell using code

Please Login or Register  to view this content.

Here while displaying my table having 0.00 as value is changes to 0, how can i retain its format when displayed in VBA?

[NeedForExcel]

You can add a line of code, something like

Selection.NumberFormat = "#,##0.00"

Change the Selection Part to the way you would want to refer to the range..

There are many different ways.. This is just one of it.

[drunkenneo]

For this i feel i have to format a precise cells, where as my data place can be changed tomorrow as table column adds. Is there any general way of doing it?

[NeedForExcel]

You can then include it in the FOR Loop Which you have up there..

That should be feasible?

Something like -

Please Login or Register  to view this content.

Note: Not very sure which cells actually need to be formatted as 0.00..

[drunkenneo]

Here is the code i added:

Please Login or Register  to view this content.

After finding the field data type it will be easier to format as you suggested.

[NeedForExcel]

True!

So did it work?

[drunkenneo]

Indeed... more info can be get from "https://support.microsoft.com/en-us/kb/193947"