ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel spreadsheets (https://www.excelbanter.com/excel-discussion-misc-queries/115962-excel-spreadsheets.html)

buggsy

excel spreadsheets
 
If anyone can help me with this question I have from school, Id appreciate
it.....Im just beginning to use excel spreadsheets. Whenever I enter a number
in a cell, excell adds a decimal point, even if the number format I use
doesnt include a decimal point. It doesnt look right to have an integer
number like 5280 displayed as 5280. with the decimal point. Is this a bug in
excel?...Is this a trick question? Is there a patch that they could download
if there is a known bug . If so, where do I download it from. or the solution
may just be in the way the user used/ formatted excel ?.. thanks for any
help/advise

Jim May

excel spreadsheets
 
go to tools, options, Edit Tab and Uncheck Fixed Decimal Places (near the
middle of the sccreen).


"buggsy" wrote:

If anyone can help me with this question I have from school, Id appreciate
it.....Im just beginning to use excel spreadsheets. Whenever I enter a number
in a cell, excell adds a decimal point, even if the number format I use
doesnt include a decimal point. It doesnt look right to have an integer
number like 5280 displayed as 5280. with the decimal point. Is this a bug in
excel?...Is this a trick question? Is there a patch that they could download
if there is a known bug . If so, where do I download it from. or the solution
may just be in the way the user used/ formatted excel ?.. thanks for any
help/advise


buggsy

excel spreadsheets
 
Thanks Jim, so you dont think it has anything to do with a known bug that
they need to download a patch for?.. I just needed to confirm that b/c ive
been trying to search online for any known virus's in excel and having
trouble.. your a champion


"Jim May" wrote:

go to tools, options, Edit Tab and Uncheck Fixed Decimal Places (near the
middle of the sccreen).


"buggsy" wrote:

If anyone can help me with this question I have from school, Id appreciate
it.....Im just beginning to use excel spreadsheets. Whenever I enter a number
in a cell, excell adds a decimal point, even if the number format I use
doesnt include a decimal point. It doesnt look right to have an integer
number like 5280 displayed as 5280. with the decimal point. Is this a bug in
excel?...Is this a trick question? Is there a patch that they could download
if there is a known bug . If so, where do I download it from. or the solution
may just be in the way the user used/ formatted excel ?.. thanks for any
help/advise


Dave F

excel spreadsheets
 
This is a feature, not a bug.
--
Brevity is the soul of wit.


"buggsy" wrote:

Thanks Jim, so you dont think it has anything to do with a known bug that
they need to download a patch for?.. I just needed to confirm that b/c ive
been trying to search online for any known virus's in excel and having
trouble.. your a champion


"Jim May" wrote:

go to tools, options, Edit Tab and Uncheck Fixed Decimal Places (near the
middle of the sccreen).


"buggsy" wrote:

If anyone can help me with this question I have from school, Id appreciate
it.....Im just beginning to use excel spreadsheets. Whenever I enter a number
in a cell, excell adds a decimal point, even if the number format I use
doesnt include a decimal point. It doesnt look right to have an integer
number like 5280 displayed as 5280. with the decimal point. Is this a bug in
excel?...Is this a trick question? Is there a patch that they could download
if there is a known bug . If so, where do I download it from. or the solution
may just be in the way the user used/ formatted excel ?.. thanks for any
help/advise



All times are GMT +1. The time now is 11:19 PM.

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