1 Reply Latest reply on Aug 30, 2012 1:56 AM by comment

    Currency decimals

    danielle-gwa

      I have created a database with a table that includes numerous price fields. I want to keep the prices all in the same format (i.e. as £1.20 and £0.99 instead of using 99p) However instead of 99p showing as £0.99, it instead appears as .99. How do i get the field to keep a 0 before the decimal place?

       

      All help would be appreciated

       

      Thanks