Re: Formatting Cells in Excel from a VB app


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Re: Formatting Cells in Excel from a VB app

  1. #1
    Sean Guest

    Re: Formatting Cells in Excel from a VB app


    I am transferring data from a grid in an excel application to an excel spreadsheet.
    I am wondering how I would format (to text) a range of cells in my excel
    spreadsheet from the VB app?

  2. #2
    Sean Guest

    Re: Formatting Cells in Excel from a VB app


    "Sean" <lonnie4ca@yahoo.ca> wrote:
    >
    >I am transferring data from a grid in an excel application to an excel spreadsheet.
    > I am wondering how I would format (to text) a range of cells in my excel
    >spreadsheet from the VB app?


    I found the answer it is:

    xlSheet.Range("A1", "Z253").NumberFormat = "@"

    to format that range of cells as text

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center