View Single Post
 
Old 09-22-2014, 04:23 PM
thetraininglady thetraininglady is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

morning.
Answer to first question is yes you can make any days below 10 show as 01, 02 etc. Simply highlight all the date cells then click the Number Format drop down menu which is the drop down menu located in the Number group on the Home tab. Select More Number Formats. From the categories choose Custom and in the Type box enter dd/mm/yyyy and press OK. All dates under 10 will now display as 01, 02, 03 etc

I'm not sure about the colouring what you mean by make it nicer. You have applied the red fill colour to those cells. You could try a different colour or even try using the formatting options in the Cell Styles options which is a button found on the Home Tab.
Reply With Quote