| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.vb.general.discussion
|
|||
|
|||
The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel
wrote We have developed an application in VB6. This application exports some results to Excel. The Excel displays error "The number in this cell is formatted as text or preceded by an apostrophe". Just as a guess, have you tried preceeding the cell contents with an = sign? My guess is that if it thinks its a function, perhaps it will do the right thing with your number.... LFS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CSV file doesn't save "xEy" style number as text formatted data | Excel Discussion (Misc queries) | |||
| VLOOKUP using a number as text to "lookup" a match formatted in a | Excel Worksheet Functions | |||
| The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel | Excel Discussion (Misc queries) | |||
| The number in this cell is formatted as text or preceded by an apostrophe | Excel Programming | |||
| The number in this cell is formatted as text or preceded by an apostrophe | Excel Programming | |||
Hybrid Mode
