Thread: NEED EXCEL FORMULA TO CONVERT 13 DIGIT ISBN TO 10 DIGIT ISBN
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
  
Posts: 3,572
Default NEED EXCEL FORMULA TO CONVERT 13 DIGIT ISBN TO 10 DIGIT ISBN
Haven't time right now, but check this out:

http://mathworld.wolfram.com/ISBN.html

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Don_Quixote60" wrote in message
...
Afraid it's not that easy.

"JE McGimpsey" wrote:

One way:

A1: 978-3456789012

A2: =RIGHT(A1,10)

In article ,
Don_Quixote60 wrote:

I HAVE ALREADY FOUND A FORMULA TO CHANGE 10 DIGIT ISBN NUMBERS TO 13
DIGIT
BUT I NEED A FORMULA TO CHANGE 13 DIGIT TO 10


Reply With QuoteReply With Quote