If i type in 23.07.68 or 23/07/68 then that is exactly what i see in the cell. I am after seeing 23 Jul 68. I have tried with and without the 1904 option. I have tried ... format, cell and selecting date etc but it does not seem to work. I am trying a formula and dragging it down as my page consits of lots of dates but the formula does not carry down.
Lady Lara is trying to work out a way of using a fullstop instead of a slash for ease of typing.
What to type in, and the formatting are two different issues.
If you format the cell "dd mmm yy" and then type in 23.7.68 Excel will see the fullstops and decide this is not a date and just treat it as text. (In the same way as if you format a cell to be a number with 2 decimal places and then type a word into the cell... it will assume the word is what you want in there and it will ignore the number format you have asked for and present the word)
If I understand the problem correctly, it can be done by using a macro to substitute what you actually type, for what you want typed.
I have a similar macro for time entry, (mostly not my own work!), and I'm sure I can ammend it to do this... but I'm not terribly quick at this, so can you confirm this is what you want before I get in to it.
Have done format cells and chose Custom. Then i typed in 'Type:' box dd-mmm-yy and it has been added to the scrolling box. Then I clicked ok. Now If i enter 23 jul 68 it adds the - in between so it reads 23-jul-68 but when i type a numerical figure 23.07.68 or 23/07/68 it does not change it. If i type 230768 it adds a totally different date
To type 23.07.68 and have it appear as a date 23 Jul 68 would be great? To be honest the (/) slash version is not playing either. I can get along the long and slow way but for the sake of number crunching dates it would save valuable time to crunch!!