| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying numeric text with leading zeros
Using
destRange.Value = SourceRange.Text doesn't work in my case since my source workbooks columns with regular text and numbers as well as numeric text. Preformatting the appropriate columns of the destination workbook as you suggest and using my original destRange.Value = sourceRange.Value statement does the trick. Thanks, Michael. -- Al C "Michael" wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CSV and Numeric Strings with Leading Zeros | Excel Worksheet Functions | |||
| Display leading zeros in numeric value without converting to text | Excel Discussion (Misc queries) | |||
| removing leading zeros in numeric fields | Excel Discussion (Misc queries) | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
| Leading Zeros in Numeric Values | Excel Worksheet Functions | |||
Hybrid Mode
