Here's befo

Column D Column E
1280-28101

Here's After

Column D Column E
1280-28101 =right(D2,4) ( this is what is displayed in the cell E3)
( should display
8101 )

Click Tools/Options on Excel's menu bar and then click the View tab on the
dialog box that appears. In the bottom section (labeled "Window
options").... is there a check mark in the Formulas entry? If so, uncheck
it.

Rick