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.