#1   Report Post  
Old January 23rd 10, 09:51 AM posted to microsoft.public.excel.setup
external usenet poster
First recorded activity by ExcelBanter: Jan 2010
Posts: 1
Default Formatting date in Excel

Hi there -
I type dates as 18.1.10 in Excel. I then have an automatic date change which
goes to 18-Jan-10. This is in 2003.
I have recently got a new computer with Windows 7 and Office 2007 and for
the life of me I can't find where I can convert the date with . separators to
the format I wish to use. It works when typed in as 18/1/10 - the conversion
is fine. I have checked in Excel Options which should be there but I can't
find it, I have tried to format it under the Number option on the Home ribbon
but it won't accept it and I have looked in Control Panel but all the
categories have changed and I don't know where to look. Can anyone help me
please? Otherwise I will have to change from years of typing with a full stop
separator to typing with a slash separator. Hopefully not!!
Many thanks.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel date formatting Arron Excel Discussion (Misc queries) 3 February 9th 09 12:30 AM
Date formatting in Excel Ricky4 Excel Discussion (Misc queries) 2 May 8th 08 04:31 PM
date formatting in excel kwood525 Excel Worksheet Functions 5 August 31st 07 07:18 PM
Formatting the Date in Excel JD Excel Discussion (Misc queries) 3 July 14th 05 11:07 PM
Date formatting in Excel vanness95678 Excel Discussion (Misc queries) 1 January 11th 05 12:24 AM

All times are GMT +1. The time now is 07:35 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017