Displaying ' before a letter

[DanielBellfield]

Good morning,

I'm looking for some help to try and solve a problem i'm encountering.

I need to it display information like this: 'C' Channel

However, it overrides and displays like this in the cell: C' Channel

But, if you check the formula bar it shows: 'C' Channel

Can anyone help on how to override the display? I've tried turning the cell just to text but it doesn't work.

Thanks in advance.

Dan

 

[Special-K99]

Enter it as
''C' Channel

Note two single quotes at beginning

 

[DanielBellfield]

Hi,

Thanks for the response, I should have mentioned... I'm using the excel document as the back bone of a website and therefore I cannot use '' as it will display on the website when I extract the information over.

I don't know whether I should ignore it and make sure that I check the values when i come to import them onto the website, but i would be handy to know that the website is going to display correctly when I launch it without much editing.

Dan