| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropping leading zeros in character fields.
Hello Group
I am programatically creating an excel work sheet loading the columns from fields in a Database file. The fields in the DB are defined as character but when the spread sheet gets created it drops the leading zeros. It assume the data is numeric but it is not. These leading zeros are required. Does anyone know how I can resolve this problem. I am using a program language called Visual RPG which is very similar to Visual Basic. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leading Zero dropping off after export to Excel | Excel Discussion (Misc queries) | |||
| How do I stop Excel from dropping leading zeros? | Excel Discussion (Misc queries) | |||
| Dropping Zeros | Excel Worksheet Functions | |||
| Converting xls to CSV file - dropping leading 0s | Excel Discussion (Misc queries) | |||
| removing leading zeros in numeric fields | Excel Discussion (Misc queries) | |||
Threaded Mode
