Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format for Leading Zeros
I'm importing a report from another workbook. How can I format column A of the destination with leading zeros in the code below? The source is formatted as General. Thanks. Code: -------------------- Dim wb As Workbook Application.ScreenUpdating = False Set wb = Workbooks.Open("C:\FOReport.xls", True, True) With ThisWorkbook.Worksheets("Report") .Range("A5:F798") = "" .Range("A5:F798").Value = wb.Worksheets("Report").Range("C7:H80").Value End With -------------------- -- DavidW ------------------------------------------------------------------------ DavidW's Profile: http://www.excelforum.com/member.php...o&userid=32630 View this thread: http://www.excelforum.com/showthread...hreadid=534117 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
leading zeros in text format | Excel Discussion (Misc queries) | |||
leading zeros fall off in csv format. | Excel Discussion (Misc queries) | |||
How do I keep leading zeros and format my cells as text? | Excel Discussion (Misc queries) | |||
Format a cell to keep leading zeros. | New Users to Excel | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |