[solved] validity check

Discuss the spreadsheet application

[solved] validity check

Postby jimbokea » Mon Apr 29, 2019 12:44 am

Hi - Had and instance where a figure 8W was entered by mistake in a column that should be just numbers. I tried using the validity being whole numbers with a pop-up that says - "Must be a whole number". This worked for 8W but I get the message for just 8 as well now. What is going on here?
- Jim
Last edited by robleyd on Mon Apr 29, 2019 2:31 am, edited 2 times in total.
Reason: Add green tick
OPenOffice 4.1.1 on Windows 7
jimbokea
 
Posts: 171
Joined: Fri Jul 15, 2011 1:10 am

Re: validity check

Postby jimbokea » Mon Apr 29, 2019 12:57 am

found problem - I had not selected greater and or less than
OPenOffice 4.1.1 on Windows 7
jimbokea
 
Posts: 171
Joined: Fri Jul 15, 2011 1:10 am


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 26 guests