G Guest Feb 27, 2004 #1 Is there a way to change the default date format in Excel from the "short date" to a "long date" format permanently.
Is there a way to change the default date format in Excel from the "short date" to a "long date" format permanently.
B bobojen Feb 27, 2004 #2 Rightclick on the cell you want to change Format Cells - under the Number tab - Catagory - Date Then just choose the date style you want
Rightclick on the cell you want to change Format Cells - under the Number tab - Catagory - Date Then just choose the date style you want
