View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.programming
[email protected] cardonline.india@gmail.com is offline
external usenet poster
 
Posts: 1
Default Convert Base 36 to base 10

On Monday, 8 February 2010 22:40:01 UTC+5:30, David wrote:
I have been given a spreadsheet with transaction numbers converted into base
36- alpha numeric - I need it in base 10- number format- I have approx 30,000
of these!- is ther a formula to convert from 1 to another?
--
Thanks for your help


@Rick Rothstein
I saw your posts. Thanks for those.
But I feel 0,1,2,...9 and A,B,C till Z adds up to 10 plus 26 equals 36 and not 37 as you have mentioned.
Please tell me where am I going wrong.
Thanks a lot.
Rajeev