Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

currency format 1

Status
Not open for further replies.
mikeba1

mikeba1

Programmer
Jan 2, 2005
235
GB
I am trying to produce a csv query based on a form.
In the query the value field has a format of #.00
All looks well when running the query, however the output csv file has a £ signn in front of the value.
Is there a way not to have the currency symbol.
Thanks
 
Sort by date Sort by votes
Have you formatted the field in the query? That is:

Format(ThisField,"Fixed")
 
Upvote 0 Downvote
Thanks Remou
I was relying on the format in the query def and putting the format in the field.
Cheers
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rccline
  • Locked
  • Question
Highlighting Duplicates with Conditional Formatting 2
2
Replies
26
Views
512
strongm
strongm
Netherby
  • Locked
  • Question
Number Format
Replies
2
Views
65
Netherby
Netherby
DeRochier
  • Locked
  • Question
Conditional formatting on Yes/No fields
Replies
2
Views
164
Axworthy
Axworthy
N2Life
  • Locked
  • Question
Last figure in a text box is partially cut off when conditionally formatted as italics 1
Replies
7
Views
150
N2Life
N2Life
thep1
  • Locked
  • Question
how to formate date in to mm/dd/yyyy 1
Replies
3
Views
57
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top