close

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: www.excelforum.com/member.php...oamp;userid=32219
View this thread: www.excelforum.com/showthread...hreadid=522276
You could go to
Format=gt;Cells=gt;currency=gt;Symbols
Select the symbol you want--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=522276Insert...Symbol

quot;davesexcelquot; gt; wrote
in message ...
gt;
gt; You could go to
gt; Format=gt;Cells=gt;currency=gt;Symbols
gt; Select the symbol you want
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=522276
gt;

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 (quot;) 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: www.excelforum.com/member.php...oamp;userid=32219
View this thread: www.excelforum.com/showthread...hreadid=522276

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()