View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paco Paco is offline
external usenet poster
 
Posts: 6
Default split a number into its digits

Hi Guys! I need to split numbers into its digits which i will latter assign
to variables. For instance:
originalNumber = 12345

then
a = 1
b = 2
c = 3
d = 4
e = 5
I am building a macro, so I cannot use the "text to columns trick" with
fixed delimiters
Thanks a lot guys!!