Change actual value to formatted value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a cell formatted to show percent with one decimal. So if the value is
29.317947274603
the cell show
29.

Is there a quick, easy way to transform the actual value in the cell to the 29.3? My problem is that this spreadsheet is being imported to another application and the extraneous digits are casuing major headaches

Emphasis on "quick, easy".
 
Hi
try
'Tools - Options - Edit' and choose 'fixed decimals'

Note: this will change all your values in this spreadsheet

--
Regards
Frank Kabel
Frankfurt, Germany

MDW said:
I've got a cell formatted to show percent with one decimal. So if the value is
29.3179472746036
the cell shows
29.3

Is there a quick, easy way to transform the actual value in the cell
Click to expand...
to the 29.3? My problem is that this spreadsheet is being imported to
another application and the extraneous digits are casuing major
headaches.
 
I think Frank meant Tools>Options>Calculation "Precision as displayed".

His note about changing all values is valid.

Gord Dibben Excel MVP
 
Gord said:
I think Frank meant Tools>Options>Calculation "Precision as
displayed".

His note about changing all values is valid.
Click to expand...

Gord
thanks for the correction - buggy translation of mine :-)
 
Back
Top