format cell thru .net
How to format the Excel cell type into percentage type or custom type through .net?
[134 byte] By [Mahendiran] at [2008-2-27] 
Hi Mahe,
Set the NumberFormat property of a Range object to the desired format code. For example, the following line changes the active cell so that it displays numbers as percentages (this/Me = Sheet1 in this example):
[C#]
this.Application.ActiveCell.NumberFormat = "0.00%";
[VB]
Me.Application.ActiveCell.NumberFormat = "0.00%"
Regards,
Steve
SteveHansen at 2007-10-2 >
Visual Studio Orcas Hot Topic
- C++/CLI great, but, w/o full WPF and WF support in the VS 2005, C# only alternative
- Infragistics xamCarouselPanel or XamDataCarousel
- Backwards Menu
- WCF and SSIS - Web Service Task
- How to open all my service''s hosts dynamically
- Retrieve Buisness Object Bound to Dependency Property
- Listbox Binding a Button to Add Items
- Viewport''s MouseLeftButtonDown-Event not firing
Visual Studio Orcas New Topic
- VS 2008 Beta 2 - "File->Save as ..." IDE Hangs Up (Vista x64)
- kerberos
- How to report bugs in Cider
- svcutil.exe Error: Cannot import wsdl:port [when class implements ISerializable]
- Unable to use WSE 3.0 with VS2008 Beta2
- Orcas Beta2 cause .NET 2.0 Framework Configuration Tools error on Vista
- Source Control Options Not Getting Saved
- Endless problems with Orcas Beta 2
Visual Studio Orcas
- ADO.NET Orcas
- XML in Orcas
- Visual Basic Orcas
- Visual C++ Orcas
- Visual C# Orcas
- Visual Studio Orcas Install and Setup
- Visual Studio Tools for Office Orcas
- Visual Studio Orcas IDE, Debugger, Build, Deployment, Help, etc.
- Visual Studio Orcas Express Editions - Installation and Setup
- Visual C++ Express Orcas
- Visual C# Express Orcas
- Visual Basic Express Orcas
- Windows Communication Foundation (Indigo)
- Windows Presentation Foundation (WPF)
- LINQ Project General
- Microsoft Synchronization Services for ADO.NET
- WPF Designer (Cider)
Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech
Site Classified
- SQL Server
- Windows Forms
- .NET Development
- Visual Basic
- Visual Studio
- Visual Studio Team System
- Visual Studio Orcas
- Visual Studio Express Editions
- Software Development for Windows Vista
- Visual C#
- Visual C++
- Smart Device Development
- SharePoint Products and Technologies
- Feedback for forums and MSDN websites
- Game Technologies: DirectX, XNA, XACT, etc.
- Visual Studio Tools for Office
- Windows Live Developer Forums
- Microsoft ISV Community Center Forums
- Internet Explorer Development
- Visual FoxPro
- Windows Search Technologies
- Audio and Video Development
- Architecture
- Commerce Server
- Gadgets
- Microsoft Robotics Studio
- Community Chat
- BizTalk Server
- Visual J#
- Windows Networking Development
- Silverlight (formerly WPF/E)
- Popfly
- SQL Server Katmai
- Connected Services Framework
- Office Live Development
- Customer Care Framework
- Incubation Technologies
- Software Engineering Discussion
- System Center
- Software Licensing and Protection Services
- Visual Studio Rosario
- Small Business Application Development
- Office
- Windows Server 2008
- JScript
- Storage Platform – Core
- Misc