Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #108785
| From | Mike S <mscir@yahoo.com> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: req. for ideas for numeric worksheet |
| Date | 2016-04-23 00:18 -0700 |
| Organization | A noiseless patient Spider |
| Message-ID | <nff7dn$cut$1@dont-email.me> (permalink) |
| References | <nfeco0$d4n$1@dont-email.me> <nfeu7t$m1k$1@dont-email.me> |
On 4/22/2016 9:41 PM, GS wrote: > Mike, > Typically.., some sort of 'code' or 'flag' is used to show current > status. What these are is entirely user specific such as your suggestion > to use "n/r", for example. I'd avoid using a slash character, though, as > your example "n/a" is an intrinsic error flag. > You don't need to be consistent in the length of the status code IMO as > it's more benefit it be descriptive in context to its usage... > T0 = Taxable at TaxRate0 (0%) > T1 = Taxable at TaxRate1 > T2 = Taxable at TaxRate2 > NT = Not Taxable > TX = Tax Exempt > ...and so on > HTH > Thanks GS, Are there any tricks for handling these characters instead of numeric input? Is my best approach to make all of the cells TEXT and then process them individually looking for either numeric or specific coded entries (like the ones you listed) when testing for legal inputs? Also is there a way to have the cells change fill and text color when certain strings are entered into them? I'm still learning Excel and wondering how to make this sheet easy to use. Thanks again, Mike
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
req. for ideas for numeric worksheet Mike S <mscir@yahoo.com> - 2016-04-22 16:43 -0700
Re: req. for ideas for numeric worksheet GS <gs@v.invalid> - 2016-04-23 00:41 -0400
Re: req. for ideas for numeric worksheet Mike S <mscir@yahoo.com> - 2016-04-23 00:18 -0700
Re: req. for ideas for numeric worksheet GS <gs@v.invalid> - 2016-04-23 11:46 -0400
Re: req. for ideas for numeric worksheet Mike S <mscir@yahoo.com> - 2016-04-23 13:49 -0700
Re: req. for ideas for numeric worksheet GS <gs@v.invalid> - 2016-04-23 17:04 -0400
Re: req. for ideas for numeric worksheet Mike S <mscir@yahoo.com> - 2016-04-23 14:15 -0700
Re: req. for ideas for numeric worksheet Claus Busch <claus_busch@t-online.de> - 2016-04-23 23:33 +0200
Re: req. for ideas for numeric worksheet Mike S <mscir@yahoo.com> - 2016-04-23 14:43 -0700
Re: req. for ideas for numeric worksheet GS <gs@v.invalid> - 2016-04-23 18:32 -0400
csiph-web