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
- Oct 18 Sat 2008 20:46
Cant make (£) Pound sign in Excel!?
close
全站熱搜
留言列表
發表留言
留言列表

