Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set datatype of a cell?
I'm creating an Excel spreadsheet from a DataTable. I've got the code all
working, but the data that I'm writing out for one particular column is "001". Excel is truncating that value to be a number, so it only displays "1". How can I set the datatype of the cell to Text, so it will preserve the leading zeroes? Thanks Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DateTime datatype in VBA | Excel Programming | |||
determining datatype | Excel Programming | |||
DataType Property | Excel Programming | |||
need help- SUB: DATATYPE FOR A CELL.. | Excel Programming | |||
How do I change the datatype of a cell? | Excel Programming |