S
Suebee55
I need the number in the formula bar to show the same number as is displayed
in the spreadsheet. I used number formatting to set up my data to 2 decimal
places. Then I set precision as displayed. I even tried it by setting
precision as displayed first then used number formatting to 2 decimal places.
Either way, not all the numbers get set to 2 decimal places. Some do and
some don't. For example, I input a value of 0.26 and the formula bar shows
it as 0.259999999999 but my input value of 0.25 shows as 0.25 in the formula
bar.
in the spreadsheet. I used number formatting to set up my data to 2 decimal
places. Then I set precision as displayed. I even tried it by setting
precision as displayed first then used number formatting to 2 decimal places.
Either way, not all the numbers get set to 2 decimal places. Some do and
some don't. For example, I input a value of 0.26 and the formula bar shows
it as 0.259999999999 but my input value of 0.25 shows as 0.25 in the formula
bar.