please reply

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi i have a proble
i want to format a cell such that it can accept only 13 digits before the decimal and 9 digits after the decima
kindly repl
srikanth
 
You must use a text string for this since excel has only 15 digits precision

--

Regards,

Peo Sjoblom

sri said:
hi i have a problem
i want to format a cell such that it can accept only 13 digits before the
Click to expand...
decimal and 9 digits after the decimal
 
Using data validation you can set Allow:decimal, Data:less than and Maximum
10000000000000. This will stop users entering more than 13digits before the
decimal point. I don't know of a way to limit the decimal places entered,
but you can set the cell formatting to only show the first 9 places.

In data validation you can alos set an error alert to let the user know why
their data has been rejected.

Ian

sri said:
hi i have a problem
i want to format a cell such that it can accept only 13 digits before the
Click to expand...
decimal and 9 digits after the decimal
 
Back
Top