Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to set 2 currency format in 1 cell??
I would like to have 2 different currency in a single cell. Is this
possible?? For example, if I want to display "SGD2 - ¥1000" in a single cell when I type in 2:1000, is this possible?? I can use other character other than semicolon (:). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to set 2 currency format in 1 cell??
If you type something like x:y, you're either going to get a time or text.
If you get text, you're not going to be able to use a number format. If you a time, my bet is that you'd never be able to reverse something like: 0.736111111 which is equal to 17:40:00 (h:m:s). I got that after I entered this 1:1000 and reformatted the cell. Even if you could do this, I bet it would be an awful way to do anything with the values. I'd use two separate cells. But if your font doesn't change, you could use two input cells and a third cell with a formula: =TEXT(A1,"""USD""#,###.00")&"-"&TEXT(B1,"""CD""#,###.00") (Formulas don't support character by character formatting.) Lee wrote: I would like to have 2 different currency in a single cell. Is this possible?? For example, if I want to display "SGD2 - ¥1000" in a single cell when I type in 2:1000, is this possible?? I can use other character other than semicolon (:). -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to set 2 currency format in 1 cell??
Hi Lee,
If your number is always a fixed number of digits (1 before and 4 after the colon), you can create a custom number format: "SGD"0-"¥"0000. Ascii code for ¥ is Alt 0165. Hope this helps! "Lee" wrote: I would like to have 2 different currency in a single cell. Is this possible?? For example, if I want to display "SGD2 - ¥1000" in a single cell when I type in 2:1000, is this possible?? I can use other character other than semicolon (:). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing cell format from text to currency | Excel Worksheet Functions | |||
Format Currency in-cell | Excel Worksheet Functions | |||
Change Currency Format of Cell based on another Cell | Excel Worksheet Functions | |||
How to format a cell to represent Indian Currency System? | Excel Discussion (Misc queries) | |||
In Format>Cell>Numbers>currency>Symbol Please add "Rs. India" | Excel Worksheet Functions |