How to paste a number with only 2 digital places

[grim72]

I have a spreadsheet where I want to run a formula but need to avoid any 'penny differences' caused by rounding up numbers.

Eg. I have a number in cell A1 showing 20.41 (but when I click on the cell it is really 20.41487). How do I copy this number and paste it into cell A2 to show only 20.41?

[Fotis1991]

Hi grim72

In A2, type the formula:

=ROUNDDOWN(A1;2)

Hope to helps you.

[teylyn]

Hello,

you cannot do that with copy and paste. Instead, you can use a formula like

=round(A1,2)

Then, if you only need the values, you can copy the result and use Paste Special > Values. Be aware, though, that depending on what you're calculating based on what source cells, the results of calculations may differ by a few pips.

cheers,

[teylyn]

@Fotis,

rounddown() may not be the best function. If A1 = 5.429, then rounddown will deliver 5.42, but round() will deliver 5.43.

Rounding should be used with caution, and rounddown() or roundup() only in cases where you really, really understand why you want to round up or down, instead of rounding according to the defaults.

cheers,

[grim72]

Thanks tetlyn, seems to have done the job.

[teylyn]

Thanks. Is it really that hard to spell my name?

[Fotis1991]

Hi teylyn.

Even for me is not so hard!!

Thank you too!

[grim72]

Whoops, apologies teylyn, I blame my fat fingers and my alcahol damaged brain cells. Thanks again though.

[teylyn]

LOL! thanks, both of you!

@grim: Alcohol should only be a factor if it's after 6pm, which seeing your location is unlikely, unless it's permanent, long-term damage from some stuff in the Spey valley or buried in old oak casks below sea level on some remote island.

Oh, all the wee drams I was privileged to sample on my trips to Scotland half a lifetime ago.