Write Excel problem

Discussion in 'Perl Misc' started by Yogee, Jun 8, 2005.

  1. Yogee

    Yogee Guest

    Hi
    I get the message
    Couldn't Parse the formula, and the string that I m writing in is not a
    Excel formula, How can I avoid a column being interpreted as formula.
     
    Yogee, Jun 8, 2005
    #1
    1. Advertisements

  2. Yogee

    pikus Guest

    put a single quote before the text. It will not be displayed and will
    not enter into any calculations etc. made upon the cell. - pikus
     
    pikus, Jun 8, 2005
    #2
    1. Advertisements

  3. "pikus" <> wrote in news:1118241689.993108.92990
    @z14g2000cwz.googlegroups.com:

    > put a single quote before the text.


    Better yet, quote some context when you are replying.

    Sinan

    --
    A. Sinan Unur <>
    (reverse each component and remove .invalid for email address)

    comp.lang.perl.misc guidelines on the WWW:
    http://mail.augustmail.com/~tadmc/clpmisc/clpmisc_guidelines.html
     
    A. Sinan Unur, Jun 8, 2005
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?SmltIEhlYXZleQ==?=

    Excel _WorkBook vs. Excel.Workbook

    =?Utf-8?B?SmltIEhlYXZleQ==?=, Sep 29, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    3,960
    Steve C. Orr [MVP, MCSD]
    Sep 29, 2004
  2. Luis Esteban Valencia
    Replies:
    1
    Views:
    1,605
    Carl Prothman [MVP]
    Jan 12, 2005
  3. =?Utf-8?B?U3JpZGhhcg==?=

    using Microsoft Excel image for Export to Excel button

    =?Utf-8?B?U3JpZGhhcg==?=, Dec 9, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    3,418
    =?Utf-8?B?U3JpZGhhcg==?=
    Dec 9, 2005
  4. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    2,006
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  5. RnkG
    Replies:
    0
    Views:
    1,687
  6. fniles
    Replies:
    6
    Views:
    889
    Karl E. Peterson
    Apr 27, 2009
  7. fniles
    Replies:
    0
    Views:
    456
    fniles
    Apr 26, 2009
  8. Replies:
    1
    Views:
    1,300
Loading...