Change Curency Symbol in Field (1 Viewer)

thorsonb

anonymust
Local time
Today, 09:17
Joined
Sep 7, 2009
Messages
12
Good day all.

I have a data base, and I have a table, a column called "Price"
for this column, i want it to be a currency, so i selected my "Data type" as currency.
but i want to change the currency symbol! I only get the dollar sign $
I would like to change it ot the Euro Symbol € how do i get this done ?

Thanks in advance.:D
 

DCrake

Remembered
Local time
Today, 19:17
Joined
Jun 8, 2005
Messages
8,632
In the table you can set the field format from Currency to Euro.

David
 

Simon_MT

Registered User.
Local time
Today, 19:17
Joined
Feb 26, 2007
Messages
2,177
You are better to have Currency in your Table rather than creating confusion as to what Currency the Price should be.

Simon
 

thorsonb

anonymust
Local time
Today, 09:17
Joined
Sep 7, 2009
Messages
12
You are better to have Currency in your Table rather than creating confusion as to what Currency the Price should be.

Simon
Huh?

You mean Type in the € Symbol each time??

I prefer to just type in the digits
eg. " 3.65 "
and then when I leave the cell, it turns to " €3.65 "
 

Kryst51

Singin' in the Hou. Rain
Local time
Today, 14:17
Joined
Jun 29, 2009
Messages
1,898
See Attachment for how.
 

Attachments

  • Format number ex.jpg
    Format number ex.jpg
    98.4 KB · Views: 1,694

Kryst51

Singin' in the Hou. Rain
Local time
Today, 14:17
Joined
Jun 29, 2009
Messages
1,898
Great minds think alike :)
 

DCrake

Remembered
Local time
Today, 19:17
Joined
Jun 8, 2005
Messages
8,632
Post #2 gave the solution, why did it take so long to resolve?
 

Misiek

Registered User.
Local time
Today, 19:17
Joined
Sep 10, 2014
Messages
249
Sorry to dig out an old post.
If you are like me, based in the UK and your only visible options are pounds (£) and euros (€) and you need the dollar symbol ($), You just need to delete the word "Currency" in your Table field format and paste this:
Code:
$#,##0.00

This is standard ANSI code.
 

Users who are viewing this thread

Top Bottom