Welcome Guest
Log In | Register )
You last visited January 19, 2017, 4:14 pm
All times shown are
Eastern Time (GMT-5:00)

Excel Formula Needed...

Topic closed. 2 replies. Last post 6 years ago by Rakster.

Page 1 of 1
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
Member #19992
August 9, 2005
2867 Posts
Offline
Posted: January 9, 2011, 6:27 pm - IP Logged

OK Excel experts I hope you can help me...

 

Is there a formula that can convert a number from straight form to box form?

Take the number 975

I need a formula to convert this number 975 to 579 the way all box numbers are portrayed.

So

291 to 129

100 to 001 and so on...

Your help is greatly appreciated.

Thanks

We are all Lucky... just some of us don't realize it!

    time*treat's avatar - radar

    United States
    Member #13130
    March 30, 2005
    2171 Posts
    Offline
    Posted: January 9, 2011, 7:03 pm - IP Logged

    As a formula: from lottaloot & Adolf

    http://www.lotterypost.com/thread/114945/399330

    As a function: from me

    http://www.lotterypost.com/thread/124458/499321

    In neo-conned Amerika, bank robs you.
    Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      Member #19992
      August 9, 2005
      2867 Posts
      Offline
      Posted: January 9, 2011, 7:10 pm - IP Logged

      Thank you...

      We are all Lucky... just some of us don't realize it!