| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The number in this cell is formatted as text or preceded by an apostrophe
I'm creating an excel 10 worksheet in vb .net. If I format a range with
oSheet.Range("G1", "Y1").NumberFormat = "0.00" the finished worksheet shows the little green triangle in each cell in the range, and it gives me the message "The number in this cell is formatted as text or preceded by an apostrophe". How do I turn these cells back into numbers with the proper numeric format? Jeremy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I FORMAT A NUMBER PRECEDED BY TWO O'S? | Excel Worksheet Functions | |||
| The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel | Excel Discussion (Misc queries) | |||
| Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions | |||
| Cell has an apostrophe and is text | Excel Discussion (Misc queries) | |||
| The number in this cell is formatted as text or preceded by an apostrophe | Excel Programming | |||
Linear Mode
