In Excel, try to pack within a column of #s by a "series" stencil but after 1000, the series rounds past its sell-by date to decimal
In Excel, I'm trying to spread within a column by series (numbers increase by 18.30) but after 1000, the series rounds past its sell-by date to nearest decimal instead of TENTH of a decimal. For example, subsequent number within series after 998.00 should be 1016.30 - instead series rounds bad to 1016. How can I fix this?
Answers:
Right click on the cell, row, column or nouns of cell you are have this problem beside. Right click> format cells>numbers, near should be an nouns to evolution the number of decimals, correct te number to 2. That should work.
go to format chose cell later number and you sould be capable of relocate it near
On ebay i get charged $11.54 and not sure why?
How much is crumb daily worth ( eco-friendly )?
Can anyone help out in relation to deposit for holiday/?
When do you guess the house souk will be in motion up?
When you receive a bill, how do you do the accounting monthly entry?
Answers:
Right click on the cell, row, column or nouns of cell you are have this problem beside. Right click> format cells>numbers, near should be an nouns to evolution the number of decimals, correct te number to 2. That should work.
go to format chose cell later number and you sould be capable of relocate it near