- Home
- Premium Memberships
- Lottery Results
- Forums
- Predictions
- Lottery Post Videos
- News
- Search Drawings
- Search Lottery Post
- Lottery Systems
- Lottery Charts
- Lottery Wheels
- Worldwide Jackpots
- Quick Picks
- On This Day in History
- Blogs
- Online Games
- Premium Features
- Contact Us
- Whitelist Lottery Post
- Rules
- Lottery Book Store
- Lottery Post Gift Shop
The time is now 10:17 am
You last visited
May 17, 2024, 10:17 am
All times shown are
Eastern Time (GMT-5:00)
3 Digit and 4 Digit Excel Formulas
Published:
Creating Boxed Numbers from inividual cells:
Pick 3 - Digit 1 = Cell A1
Digit 2 = Cell B1
Digit 3 = Cell C1
Formula in Cell D1 - =VALUE(SMALL(A1:C1,1)&SMALL(A1:C1,2)&SMALL(A1:C1,3))
Format Cell D1 > Right Click Cell D1 > Format Cells > Number Tab > Custom > enter 3 zeroes (000) in Type Box > Click OK
===============================================================================
Creating Boxed Numbers from inividual cells:
Pick 4 - Digit 1 = Cell A1
Digit 2 = Cell B1
Digit 3 = Cell C1
Digit 4 = Cell D1
Formula in Cell E1 - =VALUE(SMALL(A2:D2,1)&SMALL(A2:D2,2)&SMALL(A2:D2,3)&SMALL(A2:D2,4))
Format Cell E1 > Right Click Cell E1 > Format Cells > Number Tab > Custom > enter 4 zeroes (0000) in Type Box > click OK
Comments
Post a Comment
Please Log In
To use this feature you must be logged into your Lottery Post account.
Not a member yet?
If you don't yet have a Lottery Post account, it's simple and free to create one! Just tap the Register button and after a quick process you'll be part of our lottery community.
Register