ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   excel number problems (https://www.excelbanter.com/new-users-excel/26078-excel-number-problems.html)

excel man

excel number problems
 
why is it, that if i incert a number (say 0.8) into a cell in excel another
number comes out instead of my original number(say 0.08)

David McRitchie

tools, options, edit (tab), remove check from fixed decimal places

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"excel man" <excel wrote in message ...
why is it, that if i incert a number (say 0.8) into a cell in excel another
number comes out instead of my original number(say 0.08)





All times are GMT +1. The time now is 09:06 PM.

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