I'm importing from and excel file and i have a column that has the last 4 digits of a ssn. but in the grid, you are not allowed to put any number with a leading zero. for example 0321 would just show up as 321. i would like to have the 0321 shown. any help i really appreciate thanks
nevermind
had to format the Columns using
ugImport.DisplayLayout.Bands(0).Columns(0).Format = "0000"
then i had to use the Text in the cell to get the value, instead of using the Value property of the cell