Custom Number Formats for Excel 2007

B

Brian O

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Text in Custom Number Formats 0
Help with time formats in Excel 2007, 0
Incorrect date value when open DBF file in Excel 0
Extending existing coding to include new parameters 19
date format - excluding year 3
Adding Quote Marks To A Very Long Column. How, Please ? 1

Top