decimals

R

Rait

Hi,

Making templete file to my documents, but faced small problems.
Hope someone can point out how to get over it.

What im trying to do:

cell A - nominal value
cell b - upper tolerance
cell C - lower tolerance
cell d - actual value

now i have check where it compares actual value, will it be inside
tolerances, if not it will mark it red (simple conditional formating)


1st problem :
In cells A i want cell take decimal amount from my typed entry.
10.000 , 10.00, 10.0 or 10. In different documents same cell can have
different amount of decimals.
Like when i type in 10.000 it keeps 3 decimals, if 10.0 it keeps 1
decimal.

2nd problem :
I want cells b,c,d take decimal amount from cell a.


All ideas welcome
Rait
 
J

Jerry W. Lewis

It is considered poor manners to repeat the the same question every few
minutes until you get an answer. Once is generally sufficient; then you
have to wait for someone with interest and knowledge to read and respond
to your question.

A numeric value just has a value; it does not also carry a precision.
Thus there is no difference in the internal representation of 10., 10.0,
.... 10.000. If you need to make that distinction, you will have to
write macros to handle it, in which case you can either enter the number
as text, or format a numeric value to show the number of significant
figures. Your macro can then either count the number of text characters
beyond the decimal place or examine the format to determine the number
of decimal places.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top