I have a large equipment database that a manufacturer created when our distribution center was built. In each cell, there is a "tick" mark (i.e. 'BELT CONVEYOR) preceeding the data. The mark is not visible when unless the cell is selected. Any significance to this, where does the mark come from? More topics to follow on this mess of a database.
Tick mark in cells
- Thread starter bfraser
- Start date
It sounds like either a conditional format or some VBA doing some work
You can have tick marks as a result of either
1. Using a Symbol character from a number of different font sets that contain ticks, or
2. In Excel 2007+ there are Icon sets which also include ticks, or
3. a shape could be used with some VBA to display a tick
Without seeing the file it is hard to tell you much more
Can you post a small part of it?
You can have tick marks as a result of either
1. Using a Symbol character from a number of different font sets that contain ticks, or
2. In Excel 2007+ there are Icon sets which also include ticks, or
3. a shape could be used with some VBA to display a tick
Without seeing the file it is hard to tell you much more
Can you post a small part of it?