![]() |
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 |
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 |
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 |
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