L
Legal Learning
and be able to copy that format to many other cells. Using Excel 2003.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
CLR
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
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
L
Legal Learning
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?
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?
C
CLR
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
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
L
Legal Learning
Dear CLR,
Excellent idea. then I'll hide the column. Thanks so much.
Excellent idea. then I'll hide the column. Thanks so much.