Register Forums Today's Posts Reviews Gallery Video Vault Downloads Resources Shopping
Go Back   Mobility Site > PocketPC Software Forums > Windows Mobile OS > Windows Mobile 5

Windows Mobile 5 No more Magneto!

Reply
 
LinkBack Thread Tools
Old 03-14-06, 01:28 PM   #1 (permalink)
Aximsite Rookie
 
Join Date: Jan 2006
Posts: 22
Location: Bedford
PDA: Work
iTrader Rating: (0)
Excel in UK format

Hope that this one is going to be easy

How do i change the $ sign in the money section of excel into £, as I am in the UK?

Thanks for any help that you can give
twsKing is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
sponsor links


Old 03-15-06, 08:57 AM   #2 (permalink)
Aximsite All Star
 
kpc1's Avatar
 
Join Date: Apr 2005
Posts: 548
Location: West Cork, Ireland
PDA: X51v & X3i
Phone: SE z610i
iTrader Rating: (0)
Well, in Pocket Excel, I come up with € , and I presume that is because I have Euro selected in my regional settings. I went to Start > Settings > System > Regional Settings > Currency, and changed $ to €. Strangely, I don't see any £ option, though!

Aximsite Contest Winner 

kpc1 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-15-06, 10:26 AM   #3 (permalink)
Aximsite Veteran

 
davrol's Avatar
 
Join Date: May 2003
Posts: 1,518
Location: Cornwall UK
PDA: Axim X5 400 Mhz & X50v
iTrader Rating: (0)
1. Go to Settings\System\Regional Settings and select English (United Kingdom). Positive currency should then show £123,456,789.00. If it doesn't, go to the Currency Tab and select £ in the Currency symbol box.

2. Open Pocket Excel and open a new worksheet. Select a cell and go to Format\Cells\Number and select Currency in the Category box. Check the "use currency symbol" box. The Negative numbers box should show -£1,234.43.
mAXIMum Addiction

Aximsite Bronze Contributors Aximsite Active Bronze Member 

davrol is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-15-06, 10:46 AM   #4 (permalink)
Aximsite All Star
 
kpc1's Avatar
 
Join Date: Apr 2005
Posts: 548
Location: West Cork, Ireland
PDA: X51v & X3i
Phone: SE z610i
iTrader Rating: (0)
davrol, I thought of 1. before I replied, and changed to English (UK), but the £ sign was still not available on my machine.

Aximsite Contest Winner 

kpc1 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Tags
excel, format

sponsor links



Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel and Pocket Excel File Compatibility. Jasba X5 Forums 9 05-09-06 02:54 PM
pocket Excel .PXL format not readable in PC Excel... digitalpuppy Water Fountain 3 06-19-05 12:53 AM
Pocket Excel not saving format axim_user Applications 5 01-08-05 06:17 AM
moving excel to pocket excel marksj PDA/AXIM Newbies 2 01-26-04 06:55 PM
Pocket Excel Percent Format brox Windows Mobile 2003 2 01-09-04 09:59 PM


All times are GMT -5. The time now is 04:35 AM.