View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default forcing leading zeros as default?

I missed some kind of reference to "CSV" in the original post or is this just
for information only?


Gord

On Wed, 28 Feb 2007 16:42:20 -0500, "David McRitchie"
wrote:

Some people think that a .CSV file is an Excel file rather
than just something to pass data between different
applications.

"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Custom Formats are saved with the workbook so user will see the same formatting.


Gord Dibben MS Excel MVP

On Wed, 28 Feb 2007 13:10:13 -0800, wrapumup
wrote:

I see several questions and answers on this. I know I can go to custom format
and for example put 00000.00 to get the display with leading zeros like I
want, but is there a way to make that be the default? I am sending this file
to a user and don't want to make them do this. Thanks.