Paste Less Decimal Places

[MicrosoftUser]

I have a spreadsheet with data to 8 decimal places in it.
I have formatted it to display to 4 decimal places.
How can I copy and paste the 4 decimal places data?
ie when I subsequently click a cell I only want
4 decimal places to be in the formula bar.

 

[Niek Otten]

You could Tools>Options>Calculation>Precision as diplayed, but read Help to
be aware of the implications

--
Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[MicrosoftUser]

Perfect! Exactly what I wanted!
In case I need it in the future, is it possible to apply this
only to specified cells and not the whole sheet?

----- Niek Otten wrote: -----

You could Tools>Options>Calculation>Precision as diplayed, but read Help to
be aware of the implications

--
Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Peo Sjoblom]

You can't, besides formatting for 4 decimal places does only change what you
see in the cell,
the underlying value is still the same. You could use an event macro after
you have pasted it that will
truncate or round the value to 4 decimals or just use a help column with a
formula, then paste the values
from the formula help column as values. Either =TRUNC(A1,4) or ROUND(A1,4).
I would probably put a temporary help column in the source sheet, then use
=ROUND(A1,4), copy down as long as needed, copy it,
go to the target sheet and do edit>paste special as values. Then finally
delete the help column.

 

[Niek Otten]

No, not this way.
You would have to play around with the ROUND() function.
If you have a specific problem and can't find the solution; write again!

--
Kind Regards,

Niek Otten

Microsoft MVP - Excel