Re: Linked to Excel - data changed on export

Tech-Archive recommends: Fix windows errors by optimizing your registry

Excel does this to indicate the cell value should be treated as text - but what you've passed in is probably convertible to an int or something, so Excel explicitly states it's text by adding the (')

Simon Worth

eric db wrote: 
Hi Group:

Hope this is the right forum...

Occasionally, when I write data to a linked Excel file from a varchar(50) field, it arrives with a preceding single apostrophe (') in Excel. Doesn't seem to have the tick in SQL when I view in QA. Any ideas why this would be, or how I can avoid that?

Thanks!

eric db 
.

Relevant Pages

  • RE: new to excel...
    ... each cell which makes your data ... back TRUE, your date - even though it looks like a number, is viewed by Excel ... open up the spreadsheet that has your pasted sql data. ... > of a survey from which I need to do summaries and charts. ...
    (microsoft.public.excel.newusers)
  • Re: Excel validation.
    ... I also make the use a parameter in the SQL and link it to a cell in ... excel and when that value changes it can automatically refresh the ... this SQL uses IBM sample customer file included in ...
    (comp.sys.ibm.as400.misc)
  • using Addin in C# To Change a Range of Cells
    ... A basic data for the function, in a single cell. ... int startRow = -1; ... catch (Exception e) ... It works well when I first Define the function in excel, ...
    (microsoft.public.excel.programming)
  • Re: INT defect: Please try this on 2007 for me
    ... But clearly that is incorrect for INT, ... I simply want someone to try it in Excel 2007 and let me know the results. ... ROUND, not ROUNDDOWN. ... 40000.8479999999,9813735485076904296875 should ROUND to 40000.848 for 3 dp. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: INT defect: Please try this on 2007 for me
    ... rounding its argument to 15 significant digits before truncating to an integer". ... But clearly that is incorrect for INT, ... I simply want someone to try it in Excel 2007 and let me know the results. ... That deals effectively with ROUND, not ROUNDDOWN. ...
    (microsoft.public.excel.worksheet.functions)