Excel Only Showing # When £ has been pressed

[Gazz]

Like the title says, I noticed recently that Excel 2003 is not accepting that
the keyboard is a normal UK English keyboard. Other things such as Word or
Notepad have no problems. Every time I press Shift 3 For a £, up on the
sceen comes a #.

Must be some setting somewhere that's changed. Anyone any ideas ?

Thanks in advance.

 

[Prasadkakarla]

better u can create own macro with this symbol when ever u want u can get
with help of shortcut key. some keyboards are made differnt thats why u wont
get the symbol any way ia m workout that i willsend the proper answer reg ur
questionl. but u want pound symbol u can get from symbol then select pound
then create personal macro with that symbol and do wht ever u want.

comment (e-mail address removed) send u ropinion of this answer which
part u r useful for u

thank u

 

[Gazz]

Thanks for the response.

The thing is that this used to be ok, and has only recently started to go
wrong. Ideally I'd like to fix what's wrong rather than implement a
"work-around".

Cheers

 

[Dave F]

My thought is you have your settings set for a US style English keyboard.
Shift 3 = # on US keyboards.

Dave

 

[Gazz]

Cheers.

Could be but does that setting exist in Excel ? As mentioned no other
application has problems with this so it's not a global PC setting.

 

[Dave F]

What happens if you open a new workbook and try to enter the pound symbol?

 

[Gazz]

#

 

[SteveW]

unlikely to be just excel.
check by Opening a file, and typing £# whatever in the file name
If this isn't working it's your system settings - you've gone American

 

[SteveW]

If you are referring to Excel, then yes when I try to type the file name
during a save or save as then the £s come out as #s.

But if referring to anyother application then when I try to save the
file £s
come out as £s and #s as #s.

Like I say, it's Excel related.

that is very wierd, as the dialogue is Windows standard I'd have thought.

Have you switched to UK, non-us configuration in Windows to see what
change it makes ?

 

[Gazz]

Do you have instructions ?

I shall be most disappointed if it isn't already set to UK everywhere,
although MS do seem to like to put annoyances in form time to time.

 

[SteveW]

Do you have instructions ?

I shall be most disappointed if it isn't already set to UK everywhere,
although MS do seem to like to put annoyances in form time to time.

standard Control Panel, not aware that different applications can have
different mappings