Is there any way that I can format a cell so an operator can input tally marks and on the 5th one create the slash through like a conventional tally sheet. like llll/ (with the slash through the previous 4 marks)...Thanks for any assistance.
Is there any way that I can format a cell so an operator can input tally marks and on the 5th one create the slash through like a conventional tally sheet. like llll/ (with the slash through the previous 4 marks)...Thanks for any assistance.
Pardon ???
Entia non sunt multiplicanda sine necessitate
I'm just trying to figure out a way to format a cell in which I input 5 "i''s for example, and have it automatically turn into a single character, such as a "*" for example.
you can have the adjacent cell return a value of "*" if you have five "i"'s in a cell. Use an if formula to do this.
See this post and Brian's solution
http://www.excelforum.com/excel-misc...ly-tables.html
I think it will give you some ideas
Ed
_____________________________
Always learning, but never enough!
_____________________________
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks