If the cell entry is manually entered see Don's reply.

If a calculated entry try this.

Private Sub Worksheet_Calculate()
Me.Name = Range("A1").Value
End Sub

On 2. you can enter a static date using CTRL + ;(semi-colon)


Gord Dibben MS Excel MVP


On Wed, 16 Jul 2008 03:10:47 -0700, des-sa
wrote:

hi, i have 2 questions.
1. how do i give a sheet the same name as a cell entry in that sheet?
2. then when i enter the =now() formula, the date in that cell is kept as
the current date. is there a way to automatically convert the formula to a
number as soon as the date has been entered or in any other way?
thanks