There's no such thing as a stupid question, but they're the easiest to answer.


Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: Convert text to currency


Mermaid27's Avatar
Mermaid27 Mermaid27 is offline
Member with 13 posts.
Join Date: Dec 2009
11-Jul-2012, 04:13 PM #1
Solved: Convert text to currency
I'm using access 2010. I have a field in a table called net_total_amt which is text format. I need to convert to currency I'm thinking? It comes is as $257.87 but I need to say if it's less than $3.00 remove it. I have searched and I just don't understand some of what I read.
GeorgeJ's Avatar
GeorgeJ GeorgeJ is offline
Member with 144 posts.
Join Date: Jan 2012
Location: Scotland
Experience: Intermediate
12-Jul-2012, 10:00 AM #2
I mostly use excel, so it may not be the same - what happens if the field is not empty and you multiply by 1? Can that be compared? I use that sometimes to convert from text to value in excel.
Mermaid27's Avatar
Mermaid27 Mermaid27 is offline
Member with 13 posts.
Join Date: Dec 2009
13-Jul-2012, 12:06 PM #3
Thanks GeorgeJ. I had someone give me the syntax to convert it, which was so nice. I've never tried that in excel. Will have to now
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 55,332 posts.
Join Date: Oct 2003
Location: Surrey, UK
13-Jul-2012, 04:48 PM #4
=value(cell) will convert text to a number
use an IF

=IF(Cell<3, "" , value(cell))
so if less than 3 will just leave the cell blank
NOTE less than so 3 will still work

otherwise use <= to include 4
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

You Are Using: Server ID
Trusted Website Back to the Top ↑