Gord,

It may be a version thing but in XL97 the Formula bar changes to 05/01/2008

--


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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