Hi all,
I am trying to format three fields to write to a table.
For reasons unknow they are created as text so I tried using Cint, Clng and cdbl to export thee fields as numbers so when they are exported to an excel spreadsheet they are as number fields.
This actually works for exactly that but the end result knocks off the leading zero if the value is 0910 it ends up as 910. The source table it pulls this from actually has the leading zero if the length is less then 2.
How do I get to format the fields to numbers but keep the exact value ?
Any help is greatly appreciated.
Mitch.....
I am trying to format three fields to write to a table.
For reasons unknow they are created as text so I tried using Cint, Clng and cdbl to export thee fields as numbers so when they are exported to an excel spreadsheet they are as number fields.
This actually works for exactly that but the end result knocks off the leading zero if the value is 0910 it ends up as 910. The source table it pulls this from actually has the leading zero if the length is less then 2.
How do I get to format the fields to numbers but keep the exact value ?
Any help is greatly appreciated.
Mitch.....