But she doesn't want to see dd/mm/yyyy, she wants mm/dd/yyyy
Her problem is on the inputting of the data, not in the formatting of the
output.
--
David Biddulph

"Eduardo" wrote in message
...
Hi,
don't use culstom format select the cell, cell format and then select
date,
choose 14/03/01, it will work

"CarolAn" wrote:

I have cells with a date formated as mm/dd/yy, but when I enter the date
in
changes it as follows - if I enter 09/08/09 (Sept 8/09) it changes it to
08/09/09. When I look at it in the formula it shows is correctly as
09/08/09. What am I doing wrong?
I'm using Excel2007
--
Carolan