Assuming only one of these, use ToolsAutoCorrect

If many, perhaps a VLOOKUP table will do the trick.


Gord Dibben MS Excel MVP

On Thu, 6 Nov 2008 12:06:01 -0800, DIAMONDGIRL
wrote:

I have a text code that I want to change to the numeric equilvilant. For
example my code reads: ANY.XX and I want to convert it to read 125.00