round thousands

[shank]

How do I make (=b4*b5) = $1,250,456.23 look like $1,250K ...?

I want to just whack the end off and show the thousands.

thanks

 

[Harald Staff]

=b4*b5/1000
format cell as desired

Best wishes Harald

 

[joeu2004]

How do I make (=b4*b5) = $1,250,456.23 look like $1,250K ...?
I want to just whack the end off and show the thousands.

"Whack the end off" suggests truncating (aka rounding down). So:

="$" & trunc(b4*b5/1000,0) & "K"

Format with right alignment, if that is what you want.

 

[MartinW]

Hi Shank,

Try a custom format like this #,#,K

HTH
Martin

 

[MartinW]

Woops make that #,###,K

Hi Shank,

Try a custom format like this #,#,K

HTH
Martin