D Dave Peterson Dec 2, 2003 #2 You could create a template workbook (*.xlt) and format all the cells with the numberformat you want. Then use that whenever you want to use that special format. If you want to use that number format for all new workbooks, name the template workbook book.xlt and store it in your XLStart folder. If you save another copy as sheet.xlt, then any new sheet added to an existing workbook will inherit that number format.
You could create a template workbook (*.xlt) and format all the cells with the numberformat you want. Then use that whenever you want to use that special format. If you want to use that number format for all new workbooks, name the template workbook book.xlt and store it in your XLStart folder. If you save another copy as sheet.xlt, then any new sheet added to an existing workbook will inherit that number format.
M MS Dec 2, 2003 #3 Right click the cell. > format cells On the "Number" Tab change the format of the number to what you desire Or search help on "create a custom number format "
Right click the cell. > format cells On the "Number" Tab change the format of the number to what you desire Or search help on "create a custom number format "
