I cant make a (£) pound symbol/sign in excel, instead all I get is a
hash (#).

So when I press: 'SHIFT' and '3' I am supposed to get '£' but instead I
get '#'.

Some other keys dont work although most of the other Shift functions do
what their supposed to e.g. I can still do a dollar sign ($), percentage
sign (%) etc. All keys work fine in other apps eg. notepad. Keyboard
setting is still the set to UK format.

Any ideas?


--
paperclip
------------------------------------------------------------------------
paperclip's Profile: http://www.excelforum.com/member.php...o&userid=32219
View this thread: http://www.excelforum.com/showthread...hreadid=522276

You could go to
Format=Cells=currency=Symbols
Select the symbol you want


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522276

Insert...Symbol

"davesexcel" wrote
in message ...

You could go to
Format=Cells=currency=Symbols
Select the symbol you want


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522276

Those are good short-term solutions, but my main problem is that my
keyboard settings seem to be messed up in Excel, and Excel only.

I am using a UK keyboard which would usually require you to press Shift
and number 3, located above the letters 'W' and 'E' on the keyboard (i.e
not on the numpad) to create a £ sign but this is not the case, instead
I get a hash (#) symbol.

Also I have noticed, that Shift and number 2, located above letters 'Q'
and 'W' on the keyboard (i.e not on the numpad) should give me some
inverted commas (") but instead it give me an '@' symbol!

Anymore ideas on how to correct this?

Many thanks for the replies so far.


--
paperclip
------------------------------------------------------------------------
paperclip's Profile: http://www.excelforum.com/member.php...o&userid=32219
View this thread: http://www.excelforum.com/showthread...hreadid=522276