Formatting Dataview Results

J

Jonathan

I have written a data view for a Sharepoint site using FP2003 but all the
currency fields are formatting as £11.110000000000000000000000 rather than
£11.11. In the SQL data the value is only to 2 decimal places so why is FP
returning more and is there a way to format the results of a dataview to only
produce results to a set amount of decimals?

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge - displaying a conditional number of decimals 5
Insert dataview from XML (Excel spreadsheet) 0
Getting Radio Buttons to work, that are inserted via AutoText 0
FORMATTING RESULTS IN CALCULATED FIELD 4
Save form results to SQL database using Sharepoint Website 1
Currency format with 2 decimals not showing on report 2
create dataview webpart from FP2003 for 2003 sharepoint (sws) 3
Access keeps rounding down... Decimal 5

Top