| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 128061 | 2012-12-01 22:49:00 | Excel question | WayneMiddy (14028) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1315804 | 2012-12-01 22:49:00 | Not sure if this is possable i downlaod a table consisting of names in the left colum titles across the top and across the sheet each cell is filled with Complete or Not Complete. Can i convert them to either a tick or cross or a second option would be just Y or N? Cheers Wayne |
WayneMiddy (14028) | ||
| 1315805 | 2012-12-02 09:09:00 | Try this, open the spread sheet, click on Find & Select>Replace. Find what ---- Complete Replace with --- Y 4541 Along the bottom you have other options. Same thing with Not Complete / N You maybe able to insert a tick in the replace ( From the character coding ) , but Not to sure how to do it, the X is easy enough, but I cant get the tick to work, its in wingdings ( fonts) :) |
wainuitech (129) | ||
| 1315806 | 2012-12-02 10:10:00 | Thanks thats works great | WayneMiddy (14028) | ||
| 1 | |||||