formating cells
 

I have a worksheet that completes very simple functions, such as keeping
track of time accrued over a one month period. the cells will not allow me
to enter fractions or numbers less than one. When I enter ".75", I get the
error screen "you must enter a whole number greater than zero." The
interesting thing is that while the error screen is up, the calculations that
I have programmed (simple formula of adding across a row). When I hit the
cancel button, the data is removed from the cell. I have tried all of the
types of formatting cells and continually come across the same error message.
Can someone direct me in the right direction? Is this just a strange
glitch? i have done a moderate amount of Excel work and have never run into
this....thank you

formating cells
 

You could have Data Validation on those cells, select a cell and go to
DataValidation and see if there is a rule there, or you may have worksheet
change event code, right-click the sheet tab, select View Code from the
menu, and see if there is any code there.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jake in PGH" <Jake in wrote in message
...
I have a worksheet that completes very simple functions, such as keeping
track of time accrued over a one month period. the cells will not allow
me
to enter fractions or numbers less than one. When I enter ".75", I get
the
error screen "you must enter a whole number greater than zero." The
interesting thing is that while the error screen is up, the calculations
that
I have programmed (simple formula of adding across a row). When I hit the
cancel button, the data is removed from the cell. I have tried all of the
types of formatting cells and continually come across the same error
message.
Can someone direct me in the right direction? Is this just a strange
glitch? i have done a moderate amount of Excel work and have never run
into
this....thank you

formating cells
 

Thank you so much!!!! I was never aware that function was present. I intend
on distributing this program to a bunch of individuals that are not familiar
with excel, that will need to enter data. I fear that they will do something
wrong and hit the delete button and erase the formulas that belong to that
cell. Will locking it stop that from happening, or will I need to inservice
everyone?

thank you once again

"Jake in PGH" wrote:

I have a worksheet that completes very simple functions, such as keeping
track of time accrued over a one month period. the cells will not allow me
to enter fractions or numbers less than one. When I enter ".75", I get the
error screen "you must enter a whole number greater than zero." The
interesting thing is that while the error screen is up, the calculations that
I have programmed (simple formula of adding across a row). When I hit the
cancel button, the data is removed from the cell. I have tried all of the
types of formatting cells and continually come across the same error message.
Can someone direct me in the right direction? Is this just a strange
glitch? i have done a moderate amount of Excel work and have never run into
this....thank you

formating cells
 

No, locking should prevent that quite well.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jake in PGH" wrote in message
...
Thank you so much!!!! I was never aware that function was present. I
intend
on distributing this program to a bunch of individuals that are not
familiar
with excel, that will need to enter data. I fear that they will do
something
wrong and hit the delete button and erase the formulas that belong to that
cell. Will locking it stop that from happening, or will I need to
inservice
everyone?

thank you once again

"Jake in PGH" wrote:

I have a worksheet that completes very simple functions, such as keeping
track of time accrued over a one month period. the cells will not allow
me
to enter fractions or numbers less than one. When I enter ".75", I get
the
error screen "you must enter a whole number greater than zero." The
interesting thing is that while the error screen is up, the calculations
that
I have programmed (simple formula of adding across a row). When I hit
the
cancel button, the data is removed from the cell. I have tried all of
the
types of formatting cells and continually come across the same error
message.
Can someone direct me in the right direction? Is this just a strange
glitch? i have done a moderate amount of Excel work and have never run
into
this....thank you