Convent cell digits to hold number!

[stewart08]

hi I'm new here. I need a solution to this question:

I am trying to combine 4 single cell digits into one set of cell numbers. What I currently have works fine, but when a "0" is used as the first left digit then excel does not use it. How can this be done any help will be greatful.

need this i.e. 0 9 6 7 convents to this "0967" not to this "967"!

http://aycu07.webshots.com/image/499...5208656_rs.jpg

[darkyam]

=a1&b1&c1&d1

[stewart08]

thanks darkyam, all works now...

I thought you would like to know that its used in creation of 24 Permutations in my new 'lotto excel app'

http://aycu03.webshots.com/image/488...3671062_rs.jpg

[darkyam]

Very nice job on the formatting; I have just one question, though:
I'm not a statistics professor, but assuming the numbers are chosen completely at random, wouldn't the odds of any given 4-digit combination be the exact same as the odds for any other combination for each draw?

[stewart08]

thankx, I'm a graphic designer by day.

at the simplest level like all other lottery forcast software, this excel sheet simply counts from a Historical database. Its the counters you see, that counts Frequency, Overdue, and Skips numbers hundreds of times by excel resulting in not 'winning numbers' but good odds to pick numbers from. It can give you an edge above chance which surprisingly from time-to-time winning 'pockets of predictability' will occur

everyone is welcome to input any ideas you have...

[shg]

everyone is welcome to input any ideas you have...

Can't pass that up.

The approach would be excellent if the selection of numbers were biased, or if historical results otherwise somehow predicted future results. The notion that certain numbers will continue to come up because they're 'hot' is inherently contradictory with expecting that numbers are more likely to come up because they've been 'cold.' Which is it -- 'personal belief?'

Lotteries spend lots of money to make sure that random draws are, in fact, random. There are valid methods to choose numbers that make it less likely to share a jackpot (e.g., don't choose numbers that compose birthdays), but none that improve your chance of winnng.

It can give you an edge above chance

Hogwash. Create any prediction method that differs from random selection, apply it to historical data over a meaningful period, then test for statistical significance of above-average results.

Lotteries remain the world's largest tax on innumeracy. Prediction schemes just further prey on it.