View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Reading specific digits from a numeric variable

use MID/Left,Right The number will be coerced into a string

lngVal = 1234567890
? mid(lngVal,4,5)
45678
? left(lngVal,5)
12345
? right(lngVal,5)
67890


--
Regards,
Tom Ogilvy

"Srdjan Kovacevic" wrote in message
...
How can I read specific digits (e.g. last five digits, or the middle five

or
whatever..) from a numerical variable (A)?

The digits I read from variable A, I need to put in another numeric

variable
(B).

Thanks in advance!
srdjan