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
Dear Experts,
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". An exclamation sign appears with the cell offers "Convert to Number" option. We have controlled all this through PasteSpecial VBA code within our application. xlBook.ActiveSheet.Range("Z7").Copy xlBook.ActiveSheet.Range("A1:X10").PasteSpecial Paste:=xlPasteValues, Operation:=xlAdd, SkipBlanks:=False, Transpose:=False This code work fine if we use dot (.) as decimal separator. However for another locale setting where comma (,) is used as a decimal separator, the above block of code does not convert the values intu number (in Excel). Can anyone help me out. Any help will be highly appreciated. Thanks & Regards, Faiz |
#2
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
|
#3
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 | |||
How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions | |||
Wrapping in Excel (fitting many lines of text in cell to print rig | Excel Discussion (Misc queries) | |||
How do I set Excel cell format to "Text" from VB.NET? | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |