0

I have a specific cell in my excel sheet that contains a value from 0-100 (The value can be changed by the user). Whose value is used in some formulas at different places in the sheet.

I would like to know if there is a trick to display the cell as a string like x60 or x10 etc etc. However, when used in a formula it should be considered as a number like 60 or 10

Improve this question
3
  • 1
    Welcome to Super User. Please take a minute to clarify your question by using the edit link to add details. Do you mean the user enters the number, lets say 60, but you want Excel to show x60? Where should it display this? What have you tried so far?
    – CharlieRB
    Dec 19, 2014 at 14:08
  • Are you asking for the value in the cell to be different to what is being shown?
    – Dave
    Dec 19, 2014 at 14:13
  • @CharlieRB It should be displayed likewise in the same cell.
    – RHLK
    Dec 19, 2014 at 14:16

1 Answer 1

Reset to default
2

Apply a Custom format of:

"X"00

For example:

enter image description here

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .