Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.vb.general.discussion
external usenet poster
 
Posts: 2
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.vb.general.discussion
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CSV file doesn't save "xEy" style number as text formatted data [email protected] Excel Discussion (Misc queries) 1 July 30th 08 06:03 PM
VLOOKUP using a number as text to "lookup" a match formatted in a Maxine Excel Worksheet Functions 4 June 30th 08 03:03 AM
The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel [email protected] Excel Discussion (Misc queries) 2 July 13th 06 01:55 PM
The number in this cell is formatted as text or preceded by an apostrophe Jeremy Excel Programming 0 February 23rd 05 04:03 PM
The number in this cell is formatted as text or preceded by an apostrophe Jeremy Excel Programming 0 February 23rd 05 04:01 PM


All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"