Link to home
Start Free TrialLog in
Avatar of StuartOrd
StuartOrdFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Text appearing in cell but not in formula bar

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.
Thanks
Avatar of Enabbar Ocap
Enabbar Ocap
Flag of Italy image

Format the cell as a custom format.

Right-click - format cells - number - custom and type 0 "/yr" in the box.
ASKER CERTIFIED SOLUTION
Avatar of Enabbar Ocap
Enabbar Ocap
Flag of Italy image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of StuartOrd

ASKER

Many thanks