EXCEL results after the decimal point to retain 30?
For example, cell A1 = 12, B1 = 1.00555, C1 seek:B1 the A1 Power.
That C1 = 1.00555 12 th power.
Actual results should read:1.068671048703185048337562957558 (after the decimal point should be retained in the 30 ).
However, the use of the cell's calculation, always retained after the decimal point 14.
if the cell is set to “value”, and to retain after the decimal point 30, results from the 15th onwards, all Show for 0.
Daisen I would like to ask you, I need to be retained after the decimal precision of 30 digits, how do I do?
Thank you.
cell format will be changed to text, or in the corresponding figure before the words ” '”, that is, the single quotation marks can be! This is because Excel can be up to 15, said the accuracy of the data See the following Microsoft documents.
You want to be helpful.Excel as up to 15, said the accuracy of the data will be
cell format text can be changed, or in the corresponding figures Before adding ” '”, that is, the single quotation marks can be!
Into the text, however, and so will not be able to calculate the answer
Leave a Reply
You must be logged in to post a comment.