Enter a number of 9.75 and have it format as 0.0975
 

and be able to copy that format to many other cells. Using Excel 2003.
--
CLG

Enter a number of 9.75 and have it format as 0.0975
 

Formatting only changes the way a number appears, it does not perform math on
it. You would need a formula or VBA to do the math. Perhaps if you
explained more about what you are trying to do, someone might could help more.

Vaya con Dios,
Chuck, CABGx3



"Legal Learning" wrote:

and be able to copy that format to many other cells. Using Excel 2003.
--
CLG

Enter a number of 9.75 and have it format as 0.0975
 

Thank you so much CLR. Here is what I need to do. I want to be able to
enter numbers like 9.75, 10.50, 2.25 etc and have them calculated to that
they appear as 0.975, 0.1050, 0.225 etc. This can be done by dividing
9.75/100. How do I create a formula that references the cell's number,
divides the number by 100 and then return another number in that same cell?
--
CLG


"CLR" wrote:

Formatting only changes the way a number appears, it does not perform math on
it. You would need a formula or VBA to do the math. Perhaps if you
explained more about what you are trying to do, someone might could help more.

Vaya con Dios,
Chuck, CABGx3



"Legal Learning" wrote:

and be able to copy that format to many other cells. Using Excel 2003.
--
CLG

Enter a number of 9.75 and have it format as 0.0975
 

If you have 9.75 in cell A1, then in cell B1 you can put the formula =A1/100
and it will read 0.0975 as you desire. It is not possible with standard
fetures in excel to have the conversion take place in the same cell where the
data is entered. A cell can contain either a data entry value, or a formula
(displaying the result), but not both.

If you do not wish the data entry to appear side by side with your formula
result, then you might consider using "helper" columns located elsewhere and
the results linked to your output display.

hth
Vaya con Dios,
Chuck, CABGx3



"Legal Learning" wrote:

Thank you so much CLR. Here is what I need to do. I want to be able to
enter numbers like 9.75, 10.50, 2.25 etc and have them calculated to that
they appear as 0.975, 0.1050, 0.225 etc. This can be done by dividing
9.75/100. How do I create a formula that references the cell's number,
divides the number by 100 and then return another number in that same cell?
--
CLG


"CLR" wrote:

Formatting only changes the way a number appears, it does not perform math on
it. You would need a formula or VBA to do the math. Perhaps if you
explained more about what you are trying to do, someone might could help more.

Vaya con Dios,
Chuck, CABGx3



"Legal Learning" wrote:

and be able to copy that format to many other cells. Using Excel 2003.
--
CLG

Enter a number of 9.75 and have it format as 0.0975
 

Dear CLR,

Excellent idea. then I'll hide the column. Thanks so much.
--
CLG


"CLR" wrote:

If you have 9.75 in cell A1, then in cell B1 you can put the formula =A1/100
and it will read 0.0975 as you desire. It is not possible with standard
fetures in excel to have the conversion take place in the same cell where the
data is entered. A cell can contain either a data entry value, or a formula
(displaying the result), but not both.

If you do not wish the data entry to appear side by side with your formula
result, then you might consider using "helper" columns located elsewhere and
the results linked to your output display.

hth
Vaya con Dios,
Chuck, CABGx3



"Legal Learning" wrote:

Thank you so much CLR. Here is what I need to do. I want to be able to
enter numbers like 9.75, 10.50, 2.25 etc and have them calculated to that
they appear as 0.975, 0.1050, 0.225 etc. This can be done by dividing
9.75/100. How do I create a formula that references the cell's number,
divides the number by 100 and then return another number in that same cell?
--
CLG


"CLR" wrote:

Formatting only changes the way a number appears, it does not perform math on
it. You would need a formula or VBA to do the math. Perhaps if you
explained more about what you are trying to do, someone might could help more.

Vaya con Dios,
Chuck, CABGx3



"Legal Learning" wrote:

and be able to copy that format to many other cells. Using Excel 2003.
--
CLG