| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I change the $ sign to a £ sign in an MS template?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can I change the $ sign to a £ sign in an MS template?
I received from the UK an Excel file in which some cells have been formatted
with the currency tool - the cells of course displayed £ symbols. If I enter a number in a blank cell and clicked my currency tool (I am Canadian) I got something like £12.56 and not $12.56 If I wanted to get dollars I could use Format | Cells |Currency but I could not use the currency tool Workaround: use Format | Styles and discover that the style for the tool was pounds so I use Modify to make it dollars again Any help? Happy New Year -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "tony" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Change number when you open the excel template | Excel Discussion (Misc queries) | |||
| How do I change a template (mall) in Swedish Excel | Excel Discussion (Misc queries) | |||
| how do i change the expense statement template macro | Excel Worksheet Functions | |||
| automatically change nvoice # on template | Excel Worksheet Functions | |||
Linear Mode
