Displaying Data | SharePoint Designer Tutorial: Working with SharePoint Websites

Formatting Numbers

It is worth pointing out that it is very easy to format numbers in our data view so that they display as we would like. We can display our numbers as percentages or as a currency and specify the number of decimal places that the number should have. We can also control the 1000 separator so that commas appear in the correct places to make large numbers more easily readable.

We will take the opportunity to display our prices with a dollar sign in front of them by doing the following:

Right-click on one of the prices in our data view.
Select Format Item as.
Select Currency.
This will open the Format Number dialog. Ensure that the Symbol is set to $.
Click OK.

Notice that we only needed to select one record and that all prices were formatted in the same manner.

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

SharePoint Designer Tutorial: Working with SharePoint Websites

By : Mike Poole

SharePoint Designer Tutorial: Working with SharePoint Websites

By: Mike Poole

Overview of this book

Formatting Numbers

SharePoint Designer Tutorial: Working with SharePoint Websites

By : Mike Poole

SharePoint Designer Tutorial: Working with SharePoint Websites

By: Mike Poole

Overview of this book

Formatting Numbers

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access