Solved: Changing NumberFormat

[Howard Kaikow]

I am inserting stuff into some cells as follows:



shtExcel.Range(Cells(i, 1), Cells(i, 5)) = Split(strBuffer, vbTab)

Then, I am trying to change some of the cells to numeric format.
What do I need to use instead of the following?



shtExcel.Range(Cells(i, 2), Cells(i + j,3)).NumberFormat = "#,##0.00"

[Howard Kaikow]

It seems that I need to do the equivalent of "Convert To Number", before doing the formatting, but I have not yet found that in the Excel object model.

[Howard Kaikow]

Hey Howard, here's your answer.

Add code like the following before setting the format.


For Each rngCell In shtExcel.Range(Cells(lngFormat, 2), Cells(lngFormat + lngHigh, 3))
rngCell.Value = rngCell.Value
Next rngCell


This converts the cells from text to numeric format.

[Howard Kaikow]

Thanx Howard!
Knew I could count on you!