Return first decimal number
This tutorial shows how to extract the first decimal number using an Excel formula, with the MID and FIND functions
Hard coded formula
Cell reference formula
|
GENERIC FORMULA
=MID(number,FIND(".",number)+1,1)
ARGUMENTS GENERIC FORMULA
=MID(number,FIND(".",number)+1,1)
ARGUMENTS EXPLANATION This formula uses the FIND function to return the position of a full stop from a number and then adds one to return the position of the first number after the full stop, which represents the first decimal number. The MID function is then used to return the number with a position calculated by the FIND function.
Click on either the Hard Coded or Cell Reference button to view the formula that has the number from which you want to return the first decimal number directly entered into the formula or referenced to a specific cell. |
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Round if first decimal number is equal to | How to round if the first decimal number is equal to a specific number |
RELATED FUNCTIONS
| Related Functions | Description | Related Functions and Description |
|---|---|---|
| FIND Function | The Excel FIND function returns the position of a specific sub-string within a string | |
| MID Function | The Excel MID function returns the specified number of characters from a selected string, starting at a specified position |