Misal input cell yang dibatasi di D2Pilih Data --> Validation
Di tab Settings, Allow CustomDi box Formula tuliskan:=D2=INT(D2*100)/100
--- On Tue, 2/10/09, [email protected]
<[email protected]> wrote:
From: [email protected] <[email protected]>
Subject: ]] XL-mania [[ Membatasi Input Di Excel Dua Digit Di Belakang Koma
To: [email protected]
Date: Tuesday, February 10, 2009, 8:45 AM
Dear All XL-mania,
Saya ada masalah seperti ini, saya ingin membuat kriteria di excel bahwa user
yang melakukan input di cell yang
telah saya tentukan hanya bisa menginput maksimal 2 digit di belakang koma,
jadi yang saya maksud bukan format
cell-nya yang 2 digit di belakang koma tapi benar-benar hanya bisa input 2
digit di belakang koma.
Mohon bantuan dan pencerahannya. Terima kasih sebelumnya.
Regards,
Arief
The contents of this e-mail and attachments are confidential and subject to
legal privilege. If you are not the intended recipient, you are strictly
prohibited and may be unlawful to use, copy, store, distribute, disclose or
communicate any part of it to others and you are obliged to return it
immediately to sender or notify us and delete the e-mail and any attachments
from your system. PT BANK PERMATA TBK and subsidiaries do not accept liability
for loss or damage resulting from computer viruses. The integrity of e-mail
across the internet cannot be guaranteed and PT BANK PERMATA TBK will not
accept liability for any claims arising as a result of the use of this medium
for transmissions by or to PT BANK PERMATA TBK
