Thread: How do I format list of names formatted last,first to first last?
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default How do I format list of names formatted last,first to first last?

The rounding will go up if the value is a decimal value from say 3.5 to
4.0 and go down if it is 3.0 to 3.4999999. If you always want to round
up, change the ROUND in my example to ROUNDUP or to round down,
ROUNDDOWN.


Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=493420

Reply With QuoteReply With Quote