Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Validation Syntax Question
I'd like to restrict a user (me) from entering more than two digits after
the decimal point in a cell. I have a checkbook spreadsheet and recently discovered (by accident) that I made a withdrawal entry of 117.122 a couple of years ago, but I can't figure out how to be sure to keep from doing it again. Am I missing something simple? Thanks for any help. Jim |
#2
|
|||
|
|||
One way:
=INT(A1*100)=(A1*100) multiply by 100 and see if it's a whole number If A1 is the activecell. Another way: =MOD(A1*100,1)=0 multiply by 100 and divide by 1. Check the remainder to see if it's 0. Jim & Gail wrote: I'd like to restrict a user (me) from entering more than two digits after the decimal point in a cell. I have a checkbook spreadsheet and recently discovered (by accident) that I made a withdrawal entry of 117.122 a couple of years ago, but I can't figure out how to be sure to keep from doing it again. Am I missing something simple? Thanks for any help. Jim -- Dave Peterson |
#3
|
|||
|
|||
Thanks a million!
"Dave Peterson" wrote in message... One way: =INT(A1*100)=(A1*100) multiply by 100 and see if it's a whole number If A1 is the activecell. Another way: =MOD(A1*100,1)=0 multiply by 100 and divide by 1. Check the remainder to see if it's 0. Jim & Gail wrote: I'd like to restrict a user (me) from entering more than two digits after the decimal point in a cell. I have a checkbook spreadsheet and recently discovered (by accident) that I made a withdrawal entry of 117.122 a couple of years ago, but I can't figure out how to be sure to keep from doing it again. Am I missing something simple? Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
DATA VALIDATION IN REVERSE #2 (FOR JULIE D.) | Excel Discussion (Misc queries) | |||
Validation Data & Goto question | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Data Validation list selection question | Excel Worksheet Functions |