View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Princess Geek Princess Geek is offline
external usenet poster
 
Posts: 1
Default custom round function

I'm writing a function to change the last integer in a numeric value t
either a 5 or a 9-(replicating a Peachtree function).

The Select case functions is clearly an option, but how do I get th
function to focus on the last integer ? The * doesn't work-

example:
Change 1442 to 1445
1327.55 to 1329


thanks

--
Message posted from http://www.ExcelForum.com