| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
"E" or "O" for the first, even or odd digit in a number
hi there!
I need a formula, to say "E" if the first digit of a four-digit-number in A1 is even. and "O" if its odd. Thanks a lot! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 16th digit changes?? Problem,16th digit changes to a zero.... | Excel Worksheet Functions | |||
| Return a digit in a string of numbers | Excel Discussion (Misc queries) | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
| 16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
Threaded Mode
