| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
2.3345 I want to find out what the last 2 digits are, i.e. 45
I am lookig for a way to figure out what the last 2 digits are in a numeric
string. In my example above, I would like to know w hat the last 2 sigits are in 2.3345 and have it return a value of 45 in a new cell. Thank you. Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mistery digits on excel | Excel Discussion (Misc queries) | |||
| excel floating digits error | Excel Discussion (Misc queries) | |||
| find a cells from a range of cell | Excel Worksheet Functions | |||
| How do I find a column entry closest to a particular value | Excel Worksheet Functions | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Threaded Mode
