View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carlo carlo is offline
external usenet poster
 
Posts: 367
Default entering values without changing the function in the cell

Hi Shea

well in a cell can only be one value or a formula, but not both
simultaneously.
So, if you have a formula and you enter text into that cell, the
formula will be overwritten.

hth

Carlo

On Dec 13, 11:18 am, Shea LaRoux <Shea
wrote:
I guess I am a novice, but there should be a way for the user to input the
appropriate values in the spreadsheet I have created for them without them
changing the functions within the cells as they enter data. ??? HELP!