On Apr 10, 10:57*pm, GS wrote:
SQLUser formulated on Sunday :

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

Use a custom format for cells to receive leading zeros. For example, to
display an 8 digit part number with leading zeros...

* In the Custom format box type:
* * 0000000#

Now, if you enter 27 in the cell, Excel displays it as 00000027.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Is there a way of having the cell automatically have the 0000000# in
the Custom format when the spreadsheet is launched?


Thanks