How translate 0.51 in ‚¬ 0,51?
 

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

How translate 0.51 in ‚¬ 0,51?
 

Hi PeBe,

Format the Cells Accounting and ‚¬ English (Ireland).

Hope this Helps.
All the Best.
Paul

On Oct 17, 12:34Â*pm, PeBe wrote:
I have a text: 0.51. How can i translate it in ‚¬ 0,51?
PeBe

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