View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
des-sa[_2_] des-sa[_2_] is offline
external usenet poster
 
Posts: 74
Default naming a sheet the same as a cell in that sheet

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