Hi all,

sorry if this has already been posted before but I am looking for
user defined formula (if this doesn't already exist within Excel'
formulas) that will take a number and output it with a suffix of a 'm
for millions, 'b' for billions, 't' for trillions, etc.

So if the functions took a number like this: 104,856,000 I would lik
it to round it to the nearest million and output 105m or also if I ca
get it to display 104.86m

Can someone please point me in the right direction?

Many thanks,
Ton

--
Ton
-----------------------------------------------------------------------
Tone's Profile: http://www.excelforum.com/member.php...fo&userid=2535
View this thread: http://www.excelforum.com/showthread.php?threadid=48978