Thread: Formating
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Formating

No, not using formulas. A cell can contain a formula or a value, but not
both.

The alterntive would be to use the worksheet change event.
would you want this behavior in only one cell, one column, What? when
you say days in month, do you mean the current month?
--
Regards,
Tom Ogilvy


"vdefilippo" wrote in message
...
I want to enter a number into a cell, divide it by the number of days in

the
month, and have the answer appear in that same cell. Is that possible?

Thank you for your time.