I'm not sure what is going on as well. Generally, if a cell is
formatted as TEXT, you will experience this phenomenon. However, if
you are sure the cell with the formula is formatted as GENERAL and
still see this, I would try using the "Insert Function" method to see
if that takes.

On the main menu click InsertFunction and choose Text in the Category
drop down. Scroll down and select Right in the select box and click
OK.

enter your parameters as desired and click OK to insert this function
in the selected cell.

Does this work for you?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=473112