Good point Dave.

The scrolling around acted like a "refresh" of the display and the formula bar
changed to a date.

Also F2 + Enter will make the change.

Not so curious now<g


Gord

On Sat, 05 Jan 2008 12:53:11 -0600, Dave Peterson
wrote:

It changed for me in my short tests.

I wonder what happens if you update the display (scroll up/down)?

Or even save, close and reopen the workbook?

Gord Dibben wrote:

To add to this, if you run this macro on the cell with 39542 the value does not
change in the formula bar but will take the format in the cell.

Sub DateFormat()
Selection.NumberFormat = "dd-mmm-yyyy"
End Sub

Curious.

Gord

On Sat, 5 Jan 2008 16:26:44 -0000, "Sandy Mann"
wrote:

If I enter 39452 in a cell and format it as Accounting I see £39,452.00 in
the cell but still simply 39452 in the formula bar. If I format the cell as
a date I see 5 Jan 2008 in the cell and 05/01/2008 in the formula bar. So I
am not simply seeing in the formula bar the number formatted to look like a
date by the formatting I applied or the number that I enter