All about flooble | fun stuff | Get a free chatterbox | Free JavaScript | Avatars    
perplexus dot info

Home > Numbers
Center Digits (Posted on 2004-11-28) Difficulty: 3 of 5
A four digit number is squared to form an eight digit number. The center four digits of that square form the four digit number. Find all possible four digit numbers.

(If 'abcd' was the four digit number, then the eight digit number would look like 'wxabcdyz'.)

See The Solution Submitted by Brian Smith    
Rating: 2.2500 (4 votes)

Comments: ( Back to comment list | You must be logged in to post comments.)
re(2): Excel Solution | Comment 5 of 15 |
(In reply to re: Excel Solution by Sandeep)

I did it with Excel too but did not post as others have posted. Here's how I did it:

Column A: Listed 3163 to 9999
Column B: Square of Column A
Column C: Used rounddown function to round down B/1000000
     That gets the very first two digits (wx in this case)
Column D: Column B minus 1000000 times Column C
     This gets rid of the first two digits
Column E: Round down column D divided by 100
     This gets rid of the last two digits
Column F: Column A minus Column E
Column G: Copy Column F, Paste the values using paste special
     This is important since you cannot look for the 0 with any
     function if it's filled with a formula

Last Step: Use the find cell under Edit to find a cell with a value of 0.


  Posted by np_rt on 2004-11-28 18:35:05
Please log in:
Login:
Password:
Remember me:
Sign up! | Forgot password


Search:
Search body:
Forums (0)
Newest Problems
Random Problem
FAQ | About This Site
Site Statistics
New Comments (2)
Unsolved Problems
Top Rated Problems
This month's top
Most Commented On

Chatterbox:
Copyright © 2002 - 2017 by Animus Pactum Consulting. All rights reserved. Privacy Information