Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to set number format for the entire excel sheet
Hi all,
I am adding an excel sheet to an excel workbook using VB.NET 1.1. I am required to copy some data to this excel sheet which would be numbers like 001,002,003 etc. I want the preceding zeroes to be retained in the Excel sheet but excel is not displaying the preceeding zeroes. It is only displaying 1,2,3 etc. one way would be to set the number format for the entire sheet as 'Text' before copying data onto it. Can anyone let me know how to do it using VB.NET code. I cannot use a macro in this scenario. Thanks, CodeKracker |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 slow to copy entire sheet | Excel Discussion (Misc queries) | |||
How do I add the same number/value for an entire column in Excel? | Excel Worksheet Functions | |||
Copy the entire sheet to overlay existing sheet? | New Users to Excel | |||
How do you format a sheet to fill the entire page to print? | Excel Discussion (Misc queries) | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) |