Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007
    Posts
    26

    Unanswered: Change the format for currency

    It has been a long time since I last put up a post, I had lost interest in computers for a while. It feels good to be back

    I copied my bank account information from the banks website. Pasted it into a excel page, the currency information is -$276.00, I then copied from excel to my access database but how do I get rid of the so it is $276.00

    Your help will be much appreciated
    Regards

    casey

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    That's not really a format, it's a negative number. You could use the Abs() function if you want to change it to a positive number.
    Paul

  3. #3
    Join Date
    Dec 2007
    Posts
    26
    Perfect
    Thanks Paul

    Casey

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •