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 | |||
add apostrophe to text in cell | Excel Worksheet Functions | |||
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) | |||
Create number format for 4 digit integer preceded by zero | Excel Worksheet Functions | |||
Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions |