Custom cell format

[bamaisgreat]

Im am trying to Custom format a column of cells. What I am wanting is when someone types in 212 it show up as 2 1/2, I am unable to figure out the correct format. the reason is when someone types in a hole number like 3 it looks like this /2. I was able to do a imput mask in Access and it worked great. If you have VB code or anything on this I would appreciate it. thanks as always.

 

[Gerald Higgins]

I don't know how to do exactly that, but if you apply the "Fraction" format, and choose the appropriate option for how many digits you want to show, it will take an entry of 2.5 and show it as 2 1/2.