The number in this cell is formatted as text or preceded by an apostrophe

J

Jeremy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
What is small green triangle in upper left corner of cell? 6
"Number Formatted As Text": How To Avoid? 1
Number displayed as text difficulties 4
Problem using Match on columns of numbers with leading zeroesformatted as text ??? 4
How to prevent a number stored as text from converting to a number 2
The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel 2
Format a number field as text 3

Top