Is it possible to edit the format of a column in a sharepoint 2007 list? - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Is it possible to edit the format of a column in a sharepoint 2007 list?

Last post 11-19-2010 10:37 AM by princevis. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 11-18-2010 07:54 AM

    Is it possible to edit the format of a column in a sharepoint 2007 list?

     I have tried creating lists by importing both from an excel spreadsheet and also from an xml file.  The problem I'm having is when the data is imported, SharePoint is formating field with leading zeros (like zip code) as regular numbers, so that value 01769 shows up as 1,769.  I have specifically gone in and edited the data in the spreadsheet but that is ignored.  Do I need to do something special or can I change the data format in the datasheet view in Sharepoint?

  • 11-19-2010 07:06 AM In reply to

    Re: Is it possible to edit the format of a column in a sharepoint 2007 list?

    I found out how to change the basic data type from number to text, however, the leading zeroes are still being truncated.  Is it possible to set up custom data types or set up input masks for a column?

  • 11-19-2010 10:37 AM In reply to

    Re: Is it possible to edit the format of a column in a sharepoint 2007 list?

    You need to keep numeric datatype only, just make sure that the values of characters after decimal should be zero. If that approach wont work, create a calculated column whose value should take only integer values. Let me know if you face some problem....

    Vishal Srivastava
    Senior Software Engineer
    SDG Software Pvt Ltd
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.