Solve : spreadsheet problem?

1.	Solve : spreadsheet problem?
Answer» When using a spreadsheet with a percentages column I attempted to ALTER a percentage from 5% to 4.75%. I deleted the 5% and INSERTED 4.75% but when I exited the column the figure AUTOMATICALLY reverted to 5%. After several attempts I gave up. How can I rectify this?There is a button beneath the Number Format tab called "Increase Decimal" or Decrease Decimal". If you increase the % number by one or two decimals it should give you the 4.75% you are seeking. You probably have it set to 0 so if you increase it once it should be ok. PeterQuote from: wildwood on November 23, 2010, 05:34:39 PM There is a button beneath the Number Format tab called "Increase Decimal" or Decrease Decimal". To which version of Excel are you referring? Your REFERENCE to a "tab" is not clear. Quote from: wildwood on November 23, 2010, 05:34:39 PM If you increase the % number by one or two decimals it should give you the 4.75% you are seeking. You probably have it set to 0 so if you increase it once it should be ok. Obviously, the decimal place need to be increased twice to change from displaying 5.0% to 4.75% for numbers with two decimal places entered in a cell. I was using Excel 2007 while testing and checking this your version may vary. The cell that contains the % that you are trying to correct right click on then select Format Cells. Next Select the Tab named numbers Now under Category select Percent Then to the right set the Decimal Places Select okQuote from: Rustys on November 24, 2010, 11:47:36 AM The cell that contains the % that you are trying to correct right click on then select Format Cells. Next Select the Tab named numbers Now under Category select Percent Yes, that is a way to specify % format for a cell but he already had the cell set for % percent. I believe that's implied by "I deleted the 5% and inserted 4.75% but when I exited the column the figure automatically reverted to 5%." He just needs to increase the decimal by 2 places and that can done directly from menu in Excel 2003 or previous versions, and from wherever the feature is found in Excel 2007 or 2010.Quote from: soybean on November 24, 2010, 07:59:47 PM Yes, that is a way to specify % format for a cell but he already had the cell set for % percent. I believe that's implied by "I deleted the 5% and inserted 4.75% but when I exited the column the figure automatically reverted to 5%." He just needs to increase the decimal by 2 places and that can done directly from menu in Excel 2003 or previous versions, and from wherever the feature is found in Excel 2007 or 2010. You are correct and it was implied when I wrote that. The next step is where Decimal Places setting is.

Answer»

When using a spreadsheet with a percentages column I attempted to ALTER a percentage from 5% to 4.75%. I deleted the 5% and INSERTED 4.75% but when I exited the column the figure AUTOMATICALLY reverted to 5%. After several attempts I gave up. How can I rectify this?There is a button beneath the Number Format tab called "Increase Decimal" or Decrease Decimal". If you increase the % number by one or two decimals it should give you the 4.75% you are seeking. You probably have it set to 0 so if you increase it once it should be ok.

PeterQuote from: wildwood on November 23, 2010, 05:34:39 PM

There is a button beneath the Number Format tab called "Increase Decimal" or Decrease Decimal".

To which version of Excel are you referring? Your REFERENCE to a "tab" is not clear.

Quote from: wildwood on November 23, 2010, 05:34:39 PM

If you increase the % number by one or two decimals it should give you the 4.75% you are seeking. You probably have it set to 0 so if you increase it once it should be ok.

Obviously, the decimal place need to be increased twice to change from displaying 5.0% to 4.75% for numbers with two decimal places entered in a cell. I was using Excel 2007 while testing and checking this your version may vary.

The cell that contains the % that you are trying to correct right click on then select Format Cells.

Next Select the Tab named numbers

Now under Category select Percent

Then to the right set the Decimal Places

Select okQuote from: Rustys on November 24, 2010, 11:47:36 AM

The cell that contains the % that you are trying to correct right click on then select Format Cells.

Next Select the Tab named numbers

Now under Category select Percent

Yes, that is a way to specify % format for a cell but he already had the cell set for % percent. I believe that's implied by "I deleted the 5% and inserted 4.75% but when I exited the column the figure automatically reverted to 5%." He just needs to increase the decimal by 2 places and that can done directly from menu in Excel 2003 or previous versions, and from wherever the feature is found in Excel 2007 or 2010.Quote from: soybean on November 24, 2010, 07:59:47 PM

Yes, that is a way to specify % format for a cell but he already had the cell set for % percent. I believe that's implied by "I deleted the 5% and inserted 4.75% but when I exited the column the figure automatically reverted to 5%." He just needs to increase the decimal by 2 places and that can done directly from menu in Excel 2003 or previous versions, and from wherever the feature is found in Excel 2007 or 2010.

You are correct and it was implied when I wrote that. The next step is where Decimal Places setting is.

Solve : spreadsheet problem?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment