Formula cell and result cell in the same cell ?

  • Thread starter Thread starter Manju
  • Start date Start date
M

Manju

Hi ,


I have number which can be converted to time with help of this formula
(=TIME(A1/100,MOD(A1,100),0) , But i want reult in A1 cell itself,

Eg. If i enter 1500 in A1 it sholuld convert automatically to 3:00pm on the
same cell.

Thanks in advance.
Regards,
Manjunath
 
As far as I know it cannot be done - entering data into a cell
overwrites any thing in that cell, including formulae. But you may get
a more knowledgeable response in an Excel newsgroup or Forum, rather
than here in a FrontPage newsgroup.
 
Back
Top