Here is my formula: =RIGHT(d6,7)
Here is what is in D6: '961.110
Here is what the formula results show when you pull up the formula box:
961.110
I know the formula is calculating correcly since it shows the correct result.
However, when I hit enter to close out the formula box it displays the
formula rather than the results.

The point of this formula is to get rid of the ' apostrophe. Since I have
some nuimbers that are only one or two charaters I formatted all the cells as
text because I need all codes to have three digits a decimal and three
digits; number formats would leave off zeros in the front.

How can I get my formula to work or is there a better way to accomplish my
task?

Thanks in advance for any help.

I tried this formula in another column and it worked fine.

Any thoughts to why it did not work in the column I originally tried,
perhaps a formatiing issue?

"evoxfan" wrote:

Here is my formula: =RIGHT(d6,7)
Here is what is in D6: '961.110
Here is what the formula results show when you pull up the formula box:
961.110
I know the formula is calculating correcly since it shows the correct result.
However, when I hit enter to close out the formula box it displays the
formula rather than the results.

The point of this formula is to get rid of the ' apostrophe. Since I have
some nuimbers that are only one or two charaters I formatted all the cells as
text because I need all codes to have three digits a decimal and three
digits; number formats would leave off zeros in the front.

How can I get my formula to work or is there a better way to accomplish my
task?

Thanks in advance for any help.

does the apostrophe show up in the cell, or just in the formula bar? If it's
just in the bar, then it means that what is in the cell is text as opposed to
a number. To get rid of it, turn it back into a number with =value(d6)

"evoxfan" wrote:

I tried this formula in another column and it worked fine.

Any thoughts to why it did not work in the column I originally tried,
perhaps a formatiing issue?

"evoxfan" wrote:

Here is my formula: =RIGHT(d6,7)
Here is what is in D6: '961.110
Here is what the formula results show when you pull up the formula box:
961.110
I know the formula is calculating correcly since it shows the correct result.
However, when I hit enter to close out the formula box it displays the
formula rather than the results.

The point of this formula is to get rid of the ' apostrophe. Since I have
some nuimbers that are only one or two charaters I formatted all the cells as
text because I need all codes to have three digits a decimal and three
digits; number formats would leave off zeros in the front.

How can I get my formula to work or is there a better way to accomplish my
task?

Thanks in advance for any help.

convert to numbers and CUSTOM format as 0000000 or 0000.000

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"evoxfan" wrote in message
...
I tried this formula in another column and it worked fine.

Any thoughts to why it did not work in the column I originally tried,
perhaps a formatiing issue?

"evoxfan" wrote:

Here is my formula: =RIGHT(d6,7)
Here is what is in D6: '961.110
Here is what the formula results show when you pull up the formula box:
961.110
I know the formula is calculating correcly since it shows the correct
result.
However, when I hit enter to close out the formula box it displays the
formula rather than the results.

The point of this formula is to get rid of the ' apostrophe. Since I
have
some nuimbers that are only one or two charaters I formatted all the
cells as
text because I need all codes to have three digits a decimal and three
digits; number formats would leave off zeros in the front.

How can I get my formula to work or is there a better way to accomplish
my
task?

Thanks in advance for any help.

Your cell was formatted as text before you entered the formula.

If this happens again: Format as General or Number AND re-enter the formula
(F2, ENTER); just formatting is not enough

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"evoxfan" wrote in message
...
I tried this formula in another column and it worked fine.

Any thoughts to why it did not work in the column I originally tried,
perhaps a formatiing issue?

"evoxfan" wrote:

Here is my formula: =RIGHT(d6,7)
Here is what is in D6: '961.110
Here is what the formula results show when you pull up the formula box:
961.110
I know the formula is calculating correcly since it shows the correct
result.
However, when I hit enter to close out the formula box it displays the
formula rather than the results.

The point of this formula is to get rid of the ' apostrophe. Since I
have
some nuimbers that are only one or two charaters I formatted all the
cells as
text because I need all codes to have three digits a decimal and three
digits; number formats would leave off zeros in the front.

How can I get my formula to work or is there a better way to accomplish
my
task?

Thanks in advance for any help.