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