Which version of Excel?

For 2003 the shortcuts are described at
http://office.microsoft.com/en-us/ex...037811033.aspx, but there may
be some confusion on keyboard layout, such as which characters need the
shift key.
http://office.microsoft.com/en-us/ex...CH010503701033
shows the list differently, but still no sign of the toggling effect to
which you refer.

Interesting!
--
David Biddulph

"Gary''s Student" wrote in message
...
On my machines, CNTRL-~ switches to formula display mode and changes the
display of
1/1/2007
to
39083


A second press of CNTRL-~ reverses this.
--
Gary''s Student - gsnu200729


"David Biddulph" wrote:

It doesn't do that for me with real dates. What is CTRL-~ supposed to
do?
It looks to me as if CTRL-~ goes one way and CTRL-# goes the other way,
but
they don't toggle for me.
--
David Biddulph

"Gary''s Student" wrote in
message
...
Just make sure there are real dates in there, not text.

Take a new blank worksheet and enter a date in any cell. Then touch
CNTRL-~
several times. You will see real dates toggle back and forth between
date
format and number format.

Try this on your problem sheet.
--
Gary''s Student - gsnu200729


"Kevryl" wrote:

I've imported an Excel 200 file into Excel 2003. The date column
worked
perfectly as dd/mm on my machine in Excel 2000 but refuses to show
that
way
in 2003 on another machine. Both are XP, the original "Home edition",
the
destination machine on "Professional".

I've gone through Format/cells/number/date/ routine, and
format/cells/number/custom.

I've gone to control panel and Regional Settings . None of these
options
are
making any difference. Even blank cells in the column will not accept
the
date in the typed in format of dd/mm whereas it was never a problem in
the
originating machine under Excel 2000.

Any ideas?

Thanks in advance.