Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-07-2008, 11:09 AM
deanorx7 deanorx7 is offline
Novice
 
Join Date: Jul 2008
Posts: 2
deanorx7 is on a distinguished road
Exclamation change currency $ to £ on excel invoice help


I have tried everything regonal settings euro conversion ect.when using the invoice the values come out as $ dollers and all i want are £ pounds.please help me
Reply With Quote
  #2  
Old 07-07-2008, 02:20 PM
Matrix's Avatar
Matrix Matrix is offline Windows 10 Office 2010
Admin
 
Join Date: Jan 2005
Posts: 429
Matrix is on a distinguished road
Default

Try "Format || Cells...", click "Currency" and then you can select the desired currency under "Symbol".
Reply With Quote
  #3  
Old 07-08-2008, 01:07 AM
deanorx7 deanorx7 is offline
Novice
 
Join Date: Jul 2008
Posts: 2
deanorx7 is on a distinguished road
Default cannot access cells in format (EXCEL)INVOICE

Quote:
Originally Posted by deanorx7 View Post
I have tried everything regonal settings euro conversion ect.when using the invoice the values come out as $ dollers and all i want are £ pounds.please help me
Cannot access cells in format! how do i change this .thanks Dean
Reply With Quote
  #4  
Old 07-08-2008, 04:40 AM
Matrix's Avatar
Matrix Matrix is offline Windows 10 Office 2010
Admin
 
Join Date: Jan 2005
Posts: 429
Matrix is on a distinguished road
Default

Just right click on the cells you want to change, select "Format cells", then select currency.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening multiple Excel files within the same Excel window. lost9471 Excel 2 05-01-2010 01:57 PM
CHANGE LENGUAGE ARIIDO Office 1 10-10-2006 02:18 AM
How do I use an Excel form to populate and Excel spreadsheet apostht Excel 0 05-21-2006 11:17 AM
Change Page Layout jeffcravener Outlook 0 12-20-2005 10:42 AM
Change Display Name when printing Lucky7MQ Outlook 0 12-10-2005 10:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft