| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Number Format
I am inserting stuff into some cells as follows:
shtExcel.Range(Cells(lngRow, 1), Cells(lngRow, 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(lngFormat, 2), Cells(lngFormat + lngHigh, 3)).NumberFormat = "#,##0.00" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the format of a phone number | Excel Worksheet Functions | |||
| Changing Phone number format | Excel Worksheet Functions | |||
| Changing number format | Excel Worksheet Functions | |||
| Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
| Changing a cell's number format | Excel Programming | |||
Threaded Mode
