We help IT Professionals succeed at work.

Text appearing in cell but not in formula bar

StuartOrd used Ask the Experts™
I've been given a workbook which contains some cells that I don't understand. If I enter a number in these cells, eg "2", then the cell says "2 / yr". However the formula bar just shows "2". The cell is behaving as a number. Please can anyone explain how this has been done as I can't find where the "/ yr" is coming from.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Format the cell as a custom format.

Right-click - format cells - number - custom and type 0 "/yr" in the box.
sorry, should have said:

Right-click - format cells - number - custom, select the 0 value and type 0 "/yr" in the box.
Selecting a general number format or any other standart format will get rid of the /yr


Many thanks