Percentage cell

Posted by: ashapournami on 8 September 2017, 1:25 pm EST

  • Posted 8 September 2017, 1:25 pm EST

    Hi 


    I am using percent cell type to few of my columns in the spread. I have set the max size 100.00 and min to 0.00. The problem is like I can enter no: 2345 and the cell accepts that no: without any problem ( the reason is like it is getting stored as 23.45)


    I think it is getting multiplied by 100. Is there a way by which I can restrict this multiplication.


    Thanks                                                                                                                                                                                                                         asha

  • Replied 8 September 2017, 1:25 pm EST

    See this post...

    http://www.clubfarpoint.com/Forums/forums/thread/35822.aspx

  • Replied 8 September 2017, 1:25 pm EST

    Thanks a lot Bob. This solved my problem.


    Asha

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels