Rounding

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

Guest

Hi All,

Need some urgent help please. Thanks in advance.

How do I round to the nearest thousnad and nearest
million in Excel.

£1,000,000 would show as £1000k
£1,000,000 would show as £1m

Thanks.
 
Hi
for dispaly only use a custom format such as
£0,"k"
and
£0,,"m"

for rounding the values use
=ROUND(A1,-3)
and
=ROUND(A1,-6)

--
Regards
Frank Kabel
Frankfurt, Germany

Hi All,

Need some urgent help please. Thanks in advance.

How do I round to the nearest thousnad and nearest
million in Excel.

£1,000,000 would show as £1000k
£1,000,000 would show as £1m

Thanks.
 
Format>Cells>Custom
In the Type box, enter: (use your own currency sign instead of $)
$#,k
or
$#,,"m"

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

Hi All,

Need some urgent help please. Thanks in advance.

How do I round to the nearest thousnad and nearest
million in Excel.

£1,000,000 would show as £1000k
£1,000,000 would show as £1m

Thanks.
 
Back
Top