View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bernie Yaeger Bernie Yaeger is offline
external usenet poster
 
Posts: 8
Default dropping prefix '0's when creating a spreadsheet in code

I'm developing a vb .net function that creates a .xls or .csv for a vb .net
dataset. The guts of the routine goes something like this:
objws.Cells(rowindex, colindex) = fixedstring

When I print fixedstring to the screen, it reads, for example, '00833', but
once I save it, it becomes 833 and Excel sees it as a number, not text.
I've tried every file format I can think of, but regardless how I save it, I
get the same result. Is there something I need to do to preserve prefix
'0's and the data type as string rather than numeric?

Thanks for any help.

Bernie Yaeger