Thank you for the question. Are you using Excel?
I've tried an IF statement but can't figure how to get it to reflect the actual number is XXXXX 18.
You can use a formula like this on the cell: =IF(A2>18,"18",A2)
That just translates to, if the number is XXXXX than 18, show its value, otherwise show 18
If this works, cant thank you enough
Sure, let me know what you find
I'll get off now and try it. How do I let you know if it doesn't work?
You shouldn't have to leave this page to try it, but if you do you can bookmark this page to come back and rate my answer
This is the link: http://www.justanswer.com/computer-programming/78h73-column-numbers-ranging-29.html
you should also have an email a link as well