Excel Only Showing # When £ has been pressed
 

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.

Excel Only Showing # When £ has been pressed
 

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 send u ropinion of this answer which
part u r useful for u

thank u

"Gazz" wrote:

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.

Excel Only Showing # When £ has been pressed
 

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

Excel Only Showing # When £ has been pressed
 

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

Dave
--
Brevity is the soul of wit.


"Gazz" wrote:

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

Excel Only Showing # When £ has been pressed
 

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.

Excel Only Showing # When £ has been pressed
 

What happens if you open a new workbook and try to enter the pound symbol?
--
Brevity is the soul of wit.


"Gazz" wrote:

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.

Excel Only Showing # When £ has been pressed
 

#

:-)

Excel Only Showing # When £ has been pressed
 

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 :)

On Tue, 28 Nov 2006 21:14:54 -0000, Gazz
wrote:

#

:-)

Excel Only Showing # When £ has been pressed
 

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.

Excel Only Showing # When £ has been pressed
 

On Thu, 30 Nov 2006 00:05:00 -0000, Gazz
wrote:

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 ?

--
Steve (3)

Excel Only Showing # When £ has been pressed
 

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.

Excel Only Showing # When £ has been pressed
 

On Fri, 01 Dec 2006 23:21:00 -0000, Gazz
wrote:

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

--
Steve (3)

Excel Only Showing # When £ has been pressed
 

OK. Thanks.