Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I place currency symbols by themselves in Excel?
Hullo,
I asked this question before but perhaps I was less than specific. I want to place a currency symbol, by itself ,in a separate cell or column when using Microsoft Excel. I know about Format,cells,number headings,etc. but how do I get JUST the symbol , without other numbers, in the relevant box?? I am looking for help. Peter FREER |
#2
|
|||
|
|||
Just type it in the cell.
-- Kind regards, Niek Otten Microsoft MVP - Excel "The Angry Ant" wrote in message ... Hullo, I asked this question before but perhaps I was less than specific. I want to place a currency symbol, by itself ,in a separate cell or column when using Microsoft Excel. I know about Format,cells,number headings,etc. but how do I get JUST the symbol , without other numbers, in the relevant box?? I am looking for help. Peter FREER |
#3
|
|||
|
|||
If the symbol is on your keyboard, just type it as Niek Otten indicated.
If it is not on your keyboard, the simplest way is to copy it from the Character Map under Start Programs Accessories System Tools. Select the desired Font and look for the symbol. Click on the symbol, click Select and Copy, then return to Excel, put your cursor in the desired cell and Paste. "The Angry Ant" wrote: Hullo, I asked this question before but perhaps I was less than specific. I want to place a currency symbol, by itself ,in a separate cell or column when using Microsoft Excel. I know about Format,cells,number headings,etc. but how do I get JUST the symbol , without other numbers, in the relevant box?? I am looking for help. Peter FREER |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert currency symbols in Excel? | Excel Discussion (Misc queries) | |||
How do I input currency symbols in Excel? | Excel Discussion (Misc queries) | |||
Insert excel data source into word doc using currency symbols | Excel Worksheet Functions | |||
Using symbols for drop down list boxes? | Excel Worksheet Functions | |||
Currency Style button | Excel Discussion (Misc queries) |