Lock an entered number to a given number (maybe) question

I am not sure if I will describe this correct on the first try. I am semi-new to excel and probably need to learn it's terms better but I am going to give it a go to describe what I want to do. I am fairly certain that this has already been done but my searches have turned up empty. On to the scenario...

I would like to be able to enter a number in cell a1. Let's say 44.2. I want that number to actually be locked in as 100'-0" in cell b1. Below in the next row I want to enter another number, lets say that one is 41.5 into cell a2. And then I want the cell b2 to return the difference in feet and inches. So ultimately the only cells that I will entering data into is in column a and column b would just return information.

The other thing I am trying to figure out is a formula for converting decimal feet to feet and inches (which I have found) but a formula that is less than 40 characters.

I think that is enough to get a conversation going and any help is greatly appreciated!

Is vlookup a formula?

Is there a way to enter a number into only one cell, let's say A1, and have the same number become entered into another cell, lets say A1 on sheet 2? Without having to manually enter anything into sheet 2, A1.

Originally Posted by oeldere

Yes you can.

go in sheet 2 on cell a1.

type = sheet1!a1

Awesome, Thank you!