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 | |||
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 |