View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fredrik Wahlgren Fredrik Wahlgren is offline
external usenet poster
 
Posts: 339
Default OpenText looses leading zeros for zip


"Salty Dog" wrote in message
...
I've tried
objExcel.ActiveWorkbook.Activesheet.Columns("L").N umberFormat = "@"
and no luck.

I also tried the FieldInfo Array of Arrays for OpenText.

I'm using vbs and I'm looking for a way to not loose leading zeros?

Thanks!

Use an apostrophe as the first character, i.e '01 rather than 01
/Fredrik