Enter decimal values in cell

Can any one help me in implementing the decimal values in the cell.
At present I can only enter the integer value into the cell like 34, 45, 12, 1, etc...
But I need to enter decimal values into the cell, like 13.5, 14.34, 54.98 etc.
Please help me to implement.

Sanjay Sharma
September 25,
Alex, Could you please help me with the issue of saving the decimal values from the cell.
Sanjay Sharma
September 26,
Maybe this is the problem with your validation code?
Alex (ActiveWidgets)
September 26,
Thanks Alex,
There was a problem in my backend. Now got resolved. Thanks much for the effort.
Can you tell me how to format the values.
for example, if I have the value like 23 to change to 23.0 or 23.00 or 23.000 based on logic.
or to convert the 23.0 or 23.00 or 23.000 to 23 only.
Sanjay Sharma
September 26,
Sanjay I think you would have to write a javascript function to do this for you.
Here is an example of a function that determines if a given string is numeric.

you can adapt it to add '0' or '00' or remove it etc depending on your logic. I.e you can loop through your String and when you find a '.' stop looping and return that Integer value. etc

function isNumeric(strString) {
// check for valid numeric strings
var strValidChars = "0123456789.-";
var strChar;
var blnResult = true;

if (strString.length == 0) return false;

// test strString consists of valid characters listed above
for (i = 0; i < strString.length && blnResult == true; i++)
strChar = strString.charAt(i);
if (strValidChars.indexOf(strChar) == -1)
blnResult = false;
return blnResult;
September 28,

This topic is archived.

See also:

Back to support forum