Insert in single line of text only numbers SharePoint 2013

Insert in single line of text only numbers, which will be displayed without a commas.


Insert in Column Validation =ISNUMBER([My Column]+0)





When we try to write letters, we get a warning message.



When we enter numbers, we get numbers without  commas.

 

SharePoint column validation formula for time value - input in a single line of text field.

Here is a Column validation formulas for time value only input in a single line of text field:


Formula for hours, minutes and seconds(e.g.02:30:00):

=AND(TIMEVALUE(FieldName)<>TEXT(FieldName,"HH:MM:SS"),LEN(FieldName)=8)

 Formula for hours and minutes(e.g.02:30):

=AND(TIMEVALUE(FieldName)<>TEXT(FieldName,"HH:MM"),LEN(FieldName)=5)

Change certificate - Office Web Apps

Certificate has been expired and now we need to configure new certificate for existing web farm.
How to change office web apps certificate with powershell?


Before PowerShell command import certifikate in Personal Certifikate Store.


Open a Microsoft PowerShell window as Administrator.

Set-OfficeWebappsFarm -CertificateName "CertifikateFriendlyName"


After this command server restart is required.

Get number of subsite in a site collection - SharePoint

How to get number of subsites in a site collection using Powershell?

$site = Get-SPSite http://YourSharePointSite
$site.AllWebs.Count