Re: Weird date formatting

Tech-Archive recommends: Fix windows errors by optimizing your registry

You won't get there with just formatting.
Probably best is to use a form and echo the full date (02 August, 2002) and ask for confirmation.
I know people have their own way of filling in dates, if they feel it doesn't matter. But I bet in your country too, you are not
invited to enter license plate numbers, DOBs, passport numbers etc in any sequence you like.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Christine" <Christine@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:FBB525B8-F50A-4D26-9086-D9146451BBFD@xxxxxxxxxxxxxxxx
| Now, why didn't I think of that... The point of my post is that people are
| people, creatures of habit, and do not enter dates consistently. This is the
| reason programmers, etc. develop and use masks, automatic formatting,
| combo/list boxes, etc. to help ensure the integrity of data.
|
| "Christine" wrote:
|
| > I am brand new to Excel and am having trouble formatting a date. We have
| > different nationalities in the office where each person enters the date
| > differently:
| > * month, day, year
| > * year, month, day
| > * day month year
| >
| > Everyone defaults to their own country's way of doing things and we are
| > getting very confused! To eliminate confusion, for example, I've formatted a
| > cell "mmm-yy". But if someone enters "11-06" (for November 2006) the value
| > becomes "Jun-06". Entering "9-07" (September 2007), it becomes Jul-06". If I
| > enter "2007-8" it remains unchanged. The only time it works is if you
| > actually enter the short-form month and year (Feb-07), which is kinda missing
| > the point of formatting the cell to begin with. What is the best way around
| > this?


.

Relevant Pages

  • Re: Excel-Office 2008 for Mac
    ... Excel with capabilities of Print Preview in Word. ... view which allowed formatting changes plus other sheet editing & page break ... adjustment but didn't allow margin changes or other Setup options without ... programmers list of Important Things To Maintain When Upgrading Software, ...
    (microsoft.public.mac.office.excel)
  • RE: Excel Automation
    ... spreadsheet works PERFECTLY. ... The only issue that I have is that the EXCEL ... All of the formatting worked perfectly ... > Dim strRightRange As String ...
    (microsoft.public.access.modulesdaovba)
  • Re: Merging values into Word documents
    ... Merging a letter with currency amount fields must happen very frequently. ... bother to develop a cell format capability to display as Currency if any ... If Word's mergefields are showing the values to 4 decimal places, that's because the values are *stored* that way in Excel. ... Whether the formatting differences between Word and Excel are a 'problem' depends on your perspective. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word list to Excel
    ... In your original post, you said "I have a long list of words in a Word 2007 file". ... Not sure what the formatting was but there was no crowding or other physical hinderances. ... click on whatever Excel cell you want to use as the starting point and paste the list. ... Only in that case, or by selecting the formula bar, would everything go into one cell. ...
    (microsoft.public.excel)
  • Re: How can I copy text from Excel into Word without the grid?
    ... without the grid, but will maintain a link to the source data in Excel. ... How it displays - content, formatting, etc. - is ... gridlines you see inWord aren't borders, ...
    (microsoft.public.word.docmanagement)