View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 390
Default How translate 0.51 in ‚¬ 0,51?

Hi

use this formula

=fomat(<Cell-ref,"Currency")

this will change 0.51 to <Currency_symbol0.51

if u r using Currency Symbol as 'Euro' it will put prefix with value, or by
default put prefix as $.

"PeBe" wrote:

I have a text: 0.51. How can i translate it in ‚¬ 0,51?
PeBe

u