Automatically insert a decimal point in Excel 2010
Do you want to insert a decimal point in Excel 2010 by default when you enter a number in the cell ? You can do it easily in Excel 2010 .
You can turn on this feature by checking the option “Automatically Insert a Decimal Point” in the Excel Options .
Then you can select the number of decimal places . and click ok .
Now when you enter a numeric value inside the cell for example 123 , it will be considered as 1.23 .
If the number should not contain any decimal places , you can simply insert a period at the end of the value like 123. which will be represented as 123 .
Recently Searched terms :
- ms excel 2010 numbers in cells do not show decimals formatting issue
- access 2010 import insert decimal point
- shortcut to decimal points in excel 2010
- problem microsoft excel 2010decimal
- ms excel insert decimal place into numeric value
- microsoft excel how to insert a period automatically
- microsoft excel 2010 decimal cell
- insert period after number in excel 2010 drag down
- increase decimal in excel 2010
- how to make an adding machine insert a decimal
- how to change the inserted value into decimal in excel 2010
- how to add decimal in excel 2010
- excel write C# decimal
- excel 2010 turn of decimal separator
- excel 2010 how to enter decimal shortcut
- Access 2010 not taking decimal number
- template for indian decimal system in excel
