cell type in Excel

Discussion in 'AutoCAD' started by axa2001ro, Sep 13, 2004.

  1. axa2001ro

    axa2001ro Guest

    Hello,


    Can you tell me, please how can I format as Text the data type for a column in Excel worksheet, which is opened from AutoCAD ( using VBA)?

    Thank you!
     
    axa2001ro, Sep 13, 2004
    #1
  2. axa2001ro

    ericju Guest

    Put a single quote (apostrophe) at the beginning of the line. So if you sent to an Excel cell

    1234, Excel would interpret this as a number and give the cell General formatting. General formatting will interpret this as an integer.

    '1234, Excel will see this as a string.

    You can tell if you have it right by the cell justification. If the cell has not been previously changed, that is, default formatting, text will justify to the left of the cell automatically, numbers on the right.
     
    ericju, Sep 13, 2004
    #2
Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads

  1. GCMark Illegal Cell Type 15

  2. cadence can't work-GCMark Illegal Cell Type 15

  3. Displaying CDF parameter based on cell type?

  4. Bentley View: accessing cell libraries (*.cell, *.cdx)

  5. Code to get Excel cell data as MText source

  6. Excel: copy cell with formula?

  7. Retrieved Excel Cell values containing Excel Formulas are returned Empty.

  8. Copy Table Cell to Table Cell

Loading...