Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [number]

The tag has no usage guidance.

0
votes
1answer
15 views

How do I fix the number sequence issue? [closed]

I have the same problem, I have too many folders and I have issues like 1000 11000 12000 13000... 2000 3000 How can I fix it for 1000 2000 3000... 10000 11000 Thank you
0
votes
0answers
21 views

Swap numeric field in 2 different rows

For ease of use I've made a very simple scenairo of what i want to achieve. I have a custom list with the standard title in it. I have then added a unique numerical field on the list. so i have a list ...
1
vote
0answers
110 views

Sharepoint List - Number as percentage with default value setting

I'm working on a PowerApp linked to a list as data source and I get weird display on every number displayed as a percentage (x100). I'm trying to set a number column/field with a value between 0 and ...
0
votes
2answers
168 views

Calculated column - extract only the number from alpha numeric string

I have a alpha numeric column which has values like "XGS000042210" or "XGS000836485". How do I extract the number part alone omitting the zeros using calculated column? For eg: If the column values ...
0
votes
1answer
129 views

How to force a number field to keep zeros at the start?

I would like to use a number field to add phone number to a Sharepoint list. But if the phone number starts with 0, it is automaticly removed by default. Is there any way to keep it? I didn't want to ...
0
votes
1answer
56 views

Setting Default value for drop down based on a number field.

I have a simple request from my manager to make a change in the default Edit Form for a share point list. I have a number field which allows one decimal value and a drop down field with dedicated, ...
1
vote
2answers
114 views

Is it possible tpo use the excel weeksum function in SharePoint to return the week number from a date column?

I am new to SharePoint and I know that in Excel you can use the WEEKSUM function to return the week number from a date column. Is it possible to do the same in SharePoint 2013? If so how can this be ...
1
vote
2answers
885 views

Enabling dashes (hyphens) in a number column in SharePoint

How do you allow dashes (hyphens) to be used in a number column in SharePoint? SharePoint only allows numbers and nothing else in number columns. Is there a formula or a calculated column that can be ...
1
vote
0answers
72 views

Only Integers (List Validation Settings) with condition

I just discovered the Validation Settings and think they are so helpful! I implemented column validations that check if the number is an integer but now that gives me an error with my workflow (...
2
votes
0answers
240 views

Display SharePoint version in word documents for Content types

I have a requirement to show the version number in the word document in SharePoint 2013. For which I enable the Label in "Information Management Policy Setting" by following this URL http://www....
2
votes
1answer
210 views

How to store IP Address and very large int account numbers in list? What types are best

I'm making a list and need to store IP Addresses and Account Numbers. Basically the text or single line of text variable looks best at the moment however I am wondering if anyone else knows a better ...
2
votes
3answers
752 views

Conditional Formatting Based on Number Range

I'm trying to add conditional formatting to a custom list based on whether or not a field contains a number in a certain range (i.e., if the field contains a number less than 15, i'd like the ...
0
votes
2answers
46 views

Number SharePoint list items always starting at the top with 1, 2, 3

I need to add a field to a SharePoint list which always numbers the list items viewed on the page starting at the top with 1, 2, 3... The top row would always be number "1". Is there any way to do ...
1
vote
2answers
1k views

How to set only positive number in sharepoint 2013 column

The column Title has default setting as single line text. I would like to set validation as only positive numbers allowed, no decimal. I've tried with =ISNUMBER(PurchaseQty+0) but I still can key in ...
0
votes
1answer
716 views

How to validate the total value of multiple Number columns in a list?

In a List, I've got several number columns that users enter a value in for # of tickets. Ex: Event 1 - [ ] tickets Event 2 - [ ] tickets Event 3 - [ ] tickets Is it possible to validate the ...
0
votes
2answers
819 views

Content Editor - ordered list second level

I wanted to create multilevel ordered list in SharePoint 2013 Content Editor, with continuous counting, including numbers from upper levels. 1. Planes 2. Cars 2.1. Ferrari 2.2. BMW 3. Trains ...
12
votes
4answers
36k views

Remove comma (thousands seperator) in number field without using calculated item

Is there a way to achieve this without adding a calculated item with this format = TEXT([Customer Number], "0") ?? I'm using sharepoint 2013.
0
votes
1answer
56 views

Simple List item ID Auto-population

I have a list that I want to go up by one number automatically for each new item, the first item would be 1, then 2, and so on. I have seen a lot of solutions out there for solution to auto-number a ...
3
votes
2answers
11k views

Best practice for autonumber

What is in SharePoint 2013 on premise the best way to create an autonumber system? It's for an expense note system and it should be nice to have something like 2014/0001. I know there are different ...
2
votes
1answer
222 views

How do I get a placeholder of 0?

I want my InfoPath form to have numbers formatted like "010" instead of "10" to then sync with SharePoint. How can I get my form to show the zero placeholder instead of two digits?
1
vote
1answer
1k views

Currency Data in a Workflow variable rounds to nearest dollar, want to have cents, too

I have one list called Capital Projects with Orig Budget, Amount Spent, Amount Left. I have another list with invoices with Invoice number and TotalAmount. I wrote a workflow that runs every time an ...
1
vote
2answers
1k views

Display “NaN” instead percentage value

I'm using SharePoint 2007 and developing a custom view using SharePoint Designer 2007. I've a column of a table that should display numbers as percentage. Minimun value is 0, maximum 100. In SP ...
0
votes
0answers
184 views

Calculated Column returns excessive amount of zeros

In a Purchase Order form I'm putting together, I have line amount and total amount as calculated columns. However, when displayed in the InfoPath form, they show with a ridiculous amount of zeros at ...
0
votes
1answer
28 views

Making a number of items in one list by the entered value in another list

I have two lists. In one list I have a variable that is a number. When I put certain number (for an example 5) in that variable, I want to make that many (in this case 5) items in another list. The ...
0
votes
1answer
409 views

Programmatically adding a sequence number to the 'Title' column during item creation in SP List

As per the title above, I have a list that stores IT support requests. I need a sequence number that matches with the item ID and I want to add this sequence number to the Title of the request. I ...
1
vote
1answer
601 views

User input issue with Locale change of Site SP 2010

My site is running under SharePoint 2010. Everything is Ok except when I change the locale of my site from Regional settings from US (English) to Malay. The my web part pages where user has number ...
2
votes
2answers
9k views

Creating an Autonumber Column

Is there a way to create an autonumber column in the lists and libraries? For example I want to have a list and when a user wants to add a new value, it automatically generates a new autonumber.
3
votes
1answer
6k views

Converting number field to text field results in data loss

I have the following scenario: A standard generic list with a number column. There is a large number of list items in the list - 200000. All list items have an integer number value (no floating point)...
0
votes
1answer
2k views

XSLT for summing Number column where there are cells with no value

This is akin to this question but I couldn't get the suggested sumAll function to work. I also have several different columns to sum and it just seems silly to have a separate template for each ...
2
votes
2answers
237 views

Should I use SharePoint Number column types to store monetary values?

In SharePoint I can create a list column of type 'Number'. I need to store monetary amounts and would like to be able to use this column type rather than having to create a new one. Are values of ...