Currency and Percentage as Whole Numbers

D

DLG

Using OCW 11 in Sharepoint. Is there any way to display data using the
Currency format but without 2 decimal places for the cents and the
Percentage format without 2 additional decimal places?

TIA
Dean
 
E

Eric Kuijper

DLG,

You can use the same options for formats as in Excel. Try for example: € #,##0

You are not limited to the notations that OWC suggest. You can enter you own
notation (try € #,K).

Good luck, Eric.


"DLG" schreef:
 

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
Excel does not accept text format! 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Find 0.00% 1
Convert number to text as displayed 4
Currency 2
Rounding question 9
Finding the proper style field and the numbered paragraph value within the style 0

Top