I want to put a date automatically in a specific cell in excell. Not as the format available in format date. I want the date looks like this this 01 January 2007. Thanks to everyone.
Date format in excell as 01 January 2007?
Easy:
Click Format, Cells, on the Number tab select Custom, and enter dd mmmm yyyy
That's all.
Reply:Open Excel, right click go to format, click on Date and choose the format that you like. If there isn't one that you like or exactly desire then simply choose TEXT under the Number TAB. And whatever you type will appear as typed.
No comments:
Post a Comment