Cant make (£) Pound sign in Excel!?

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?

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

Insert...Symbol

"davesexcel" <[email protected]> wrote
in message news:[email protected]...
>
> 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.

Yep, I'm suffering the identical problem. Feels like a change to keyboard language set up to me. But it's only adversely affecting Excel (Word, etc still behaving themselves). Did anyone crack this with a long term solution? #, @, £ and " all not where I expect them to be (i.e. under the key with that symbol on!)

Hi there I had the same problem.

Press Left Alt + Left Shift. That should change your characters to the way you want it.

I found my solution via this link...
http://en.kioskea.net/forum/affich-1...ing-wrong-sign

But when you get to the Language box click on Details.
Then click on Key Settings. You will see here a description of how to change hot key settings.

Regards
richgoof

Entering Symbols With The Keyboard
If you know the code number, you can enter that character any time by holding down the ALT key, and typing the 4-digit code number on the numeric keypad (the keys on the far right of your keyboard -- do not use the "normal" number keys above the letter keys). Even though character code numbers are only three digits (between 0 and 255), you must type in the leading zeros to ensure that you get the proper character. For example, to enter in the British Pound sign, whose code is 163, hold down the ALT key, and type 0163 on the numeric keypad.
Common Symbols And Codes
Euro € 0128
Ellipsis … 0133
Dagger † 0134
Double Dagger ‡ 0135
Bullet • 0149
Trademark ™ 0153
Cents ¢ 0162
Pounds £ 0163
Yen ¥ 0165
Copyright © 0169
Registered ® 0174
Plus/Minus ± 0177
Paragraph ¶ 0182
Degree ° 0176