Formatting - add an "x" to the end of a number

[bdschleich]

I would like to format a cell so that a number can be entered in to a cell, such as 1.25, and the cell will be formated so that it will automatically add an "x" at the end of the number (i.e. the cell shows 1.25x). In other words, I want the number to be enetered as a number but reflected as a multiple - any thoughts on how to do this? Thanks!

 

[Aladin Akyurek]

Custom format the entry cells as:

General"x"

 

[barry houdini]

Try using Format > Cells > Number > Custom

and in the box type

0.00"x"

 

[lenze]

You can custom format your cell(s)

#.00"x"

lenze