formula help
Got another one for ya...
D22: 1,305,393
I need E4: 1,305. (need that decimal and the comma)
I am rounding to the nearest thousand, and then abbreviating it.
Like my other question, D22 will vary from day to day and will not
always
have the same number of characters. Tomorrow it could be D22: 787,409
and I
would need 787.
Perhaps this...
E4: =TEXT(INT(D22/1000),"#,###.")
He said he wanted rounding to the *nearest* thousand, so wouldn't
=TEXT(D22/1000,"#,###.") be better?
Damn! You are probably right... the word "nearest" simply didn't register
when I first read it. Thanks for picking up on that.
Rick
|