Paste Less Decimal Places

You could ToolsOptionsCalculationPrecision as diplayed, but read Help to
be aware of the implications

--
Kind Regards,

Niek Otten

Microsoft MVP - Excel
"MicrosoftUser" wrote in message
...
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.

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 editpaste special as values. Then finally
delete the help column.




--

Regards,

Peo Sjoblom


"MicrosoftUser" wrote in message
...
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.

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
"MicrosoftUser" wrote in message
...
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 ToolsOptionsCalculationPrecision as diplayed, but read
Help to
be aware of the implications

--
Kind Regards,

Niek Otten

Microsoft MVP - Excel
"MicrosoftUser" wrote in
message
...
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.