ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   cells will not accept decimals.will not allow any retype with deci (https://www.excelbanter.com/excel-worksheet-functions/36715-cells-will-not-accept-decimals-will-not-allow-any-retype-deci.html)

detmar corp

cells will not accept decimals.will not allow any retype with deci
 
in excel only the cell size will not accept the decimal point. you can incert
the decimal but it will revert to no decimal. Also the decimal/del key on the
key pad
prints a zero rather than a decimal. Only when you open the cell will the
decimal
/del key print a decimal,close the cell it will print a zero again.

Kassie

Hi detmar

Your cells are most likely formatted as numbers, no decimal figures. Select
the cell, right click, click on format cells, and change the number format to
numbers, 2 decimal points, and you will see your decimal fractions
--
ve_2nd_at. Randburg, Gauteng, South Africa


"detmar corp" wrote:

in excel only the cell size will not accept the decimal point. you can incert
the decimal but it will revert to no decimal. Also the decimal/del key on the
key pad
prints a zero rather than a decimal. Only when you open the cell will the
decimal
/del key print a decimal,close the cell it will print a zero again.



All times are GMT +1. The time now is 12:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com