Re: Date Format - Conversion

You didn't turn on "formula view" accidentally by any chance? Tools,
Options, View, Formulas. The shortcut for this setting,

Ctrl-`

is very easy to hit by mistake.

--
Jim
"tinkertoy" <tinkertoy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:24678786-4412-4473-AA49-162954E7AEEF@xxxxxxxxxxxxxxxx
| User has a spread*** with dates - It used to be formated as Month-day
| (Mar-01). "All of a sudden" the column now displays another date format -
| example 38569 - in the cell, in the formula field it shows the correct
day,
| but as mm/dd/yyyy. The format of the column is date. We looked at
another
| formula - example ="01/01/1900"+38569 and it shows in the formula field as
| the correct date - so this is the count of days from 01/01/1900 - how do
we
| convert it back? BTW we copied the entire spread*** to a new one - and
the
| date displays correctly!
| --
| Rona/tinkertoy


.