View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lee lee is offline
external usenet poster
 
Posts: 184
Default 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 (:).