Hi Everyone,I've been googling all morning but can't seem to find an answer to my question, well two questions really.1) How to remove the comma from displaying in number columns. I can't change them to single lines of text as they are involved in calculations and have to be numbers. 2) Is it possible to start a number with a zero, for example 01, 02. SharePoint automatically removes the 0. Again this has to be a number column as it is involved in calculations. Any ideas?

There are 2 possible ways to achieve this task 1. To create a custom number field using object model OR 2. Use single line of text column to store numbers, create a calculated field that mirrors the number in the text field Set the data type returned from the formula as number hide that field from the view Let me know if you have any questions--Cheers

Hi Prasath, I tried the second option you provided.Even after selecting data type returned from the formula as number ,Still it is accepting alphanumeric fields. Can you tell an other wayout?

there is also XSLT if you're using SharePoint Designer # signs are for the leading number fixed width format <xsl:value-of select="format-number(sum($loNodeSet/@Number), '#0;-#0')"/> 01 --> 09 --> 10 --> 100 (+-)<xsl:value-of select="format-number(sum($loNodeSet/@Number), '#,##0.000;-#,##0.000')"/> 0,001.000 --> 0,009.000 --> 1,000.999 --> 10,000.999 (+-)