Hi Robin,
I don't think so but I think I know what you need to do.
Essentially I think you have managed to set the formatting to be "GBP"
rather than "£". To put it right, do the following:
1. Select the cells you wish to format as currency.
2. Press Control+1 (on the number row) to go into the formatting dialogue
box.
3. Select the "Numbers" tab and tab onto the first item for selecting the
preferred type of numbering. Select the "Currency" option from this drop
down.
4. Tab until you are on the "Symbol" option and press the Home key to go to
the top of the list. Press DownArrow once and you should now be on the £
sign.
5. Tab to the OK button and the job should be done.
Hope this helps.
Jamie
-----Original Message-----
From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx] On
Behalf Of Robin Clayden (Redacted sender "robin.clayden" for DMARC)
Sent: 22 April 2016 17:15
To: jaws-uk@xxxxxxxxxxxxx
Subject: [jaws-uk] Re: Excel 2007, GBP or the £ sign
Hi again, maybe I have the answer myself.
When I key F2 to read the contents of the cell with the arrow keys, it just
shows 10 there, so is this perhaps a dictionary thing?
Strange if so, but I'll make a new entry in the excel.jdf file for this.
-----Original Message-----
From: Robin Clayden (Redacted sender "robin.clayden" for DMARC)
Sent: Friday, April 22, 2016 5:07 PM
To: Jaws-UK List
Subject: [jaws-uk] Excel 2007, GBP or the £ sign
Hi all,
Excel 2007 and Jaws 17 latest build, Windows 10
When formatting cells in a sheet, I want to select currency and £'s but the
only option I can select is GBP. Every cell contains this and reads as "GBP
10.00" instead of simply £10
Is this a qwerk in the latest Jaws or something in Excel I need to reset
perhaps? I have removed and re installed my Office 2007 Suite twice now and
I'm puzzled.
Cheers, Robin
** To leave the list, click on the immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** jaws-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** jaws-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** jaws-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq
