View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SQLUser SQLUser is offline
external usenet poster
 
Posts: 4
Default Cells drop leading zeros from numbers

Is there a way to have a cell default to a text format without having
the spreadsheet already open?
The reason is that numbers that have a leading zeros are removed when
data is placed into the spreadsheet becuse the cell format is set to
General.

I have an application that will place a report into Excel when the
Excel icon is selected.


Thanks in Advance,

Mike