Thread: VBA to identify last digit in integer
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
brucemc[_8_] brucemc[_8_] is offline
external usenet poster
  
Posts: 1
Default VBA to identify last digit in integer

I need to identify the last digit in a test integer.

I presently am about to convert the integer to a string, use
Right(TestInteger,1) to extract the last character, then convert that
character back to a value. Seems to me I, once again, am probably
missing some other painfully obvious and easier means.

Any ideas?


--
brucemc
------------------------------------------------------------------------
brucemc's Profile: http://www.excelforum.com/member.php...o&userid=32871
View this thread: http://www.excelforum.com/showthread...hreadid=546104

Reply With QuoteReply With Quote