Prev: Can a Excel Spreadsheet automaticly open only once a week?
Next: How to stop Excel from automatically truncating leading zeros
From: Brian O on 13 Apr 2010 15:50
Hello

I open several Excel spreadsheets daily that include a date/time column.
Every spreadsheet that I open I have to change the column formatting to "dddd
dd-mmm-yy hh:mm:ss". This is not a format built into Excel 2007, is there a
way to permanently add this format to the "Custom" section...or to Excel 2007
in general?

Thanks,
Brian
From: Gord Dibben on 13 Apr 2010 18:14
Any custom formats you write will be saved with that workbook only.

New workbooks or those opened without the saved custom format will have to
be formatted as you wish.

You could record a macro while formatting and store that in your
Personal.xls

Assign to a button on the QAT


Gord Dibben MS Excel MVP



On Tue, 13 Apr 2010 12:50:01 -0700, Brian O
<BrianO(a)discussions.microsoft.com> wrote:

>Hello
>
>I open several Excel spreadsheets daily that include a date/time column.
>Every spreadsheet that I open I have to change the column formatting to "dddd
>dd-mmm-yy hh:mm:ss". This is not a format built into Excel 2007, is there a
>way to permanently add this format to the "Custom" section...or to Excel 2007
>in general?
>
>Thanks,
>Brian

 | 
Pages: 1
Prev: Can a Excel Spreadsheet automaticly open only once a week?
Next: How to stop Excel from automatically truncating leading zeros