You are viewing limited content. For full access, please sign in.

Question

Question

force staff to insert a period instead of a comma in the number field

asked on December 6, 2021 Show version history

Hi, I'm trying to force staff  to put a period instead of a comma in the number field. Sometimes I see this $12,55 instead of $12.55   or $2,354,75 instead of $2,354.75

How can I force this?

0 0

Replies

replied on December 6, 2021

Are you using a number field, a currency field, or a text field?

0 0
replied on December 6, 2021

sorry, I miss wrote this whole post. What I meant to write is: force staff to insert a period  on this number field instead of a comma.

Ex. 12.5 instead of 12,0  or

      3,452.8 instead of 3,452,8

This is not a currency dilemma. I'm actually trying to retrieve miles distance. So, no currency involved. Sorry

0 0
replied on December 7, 2021

The Question remains valid. With a number field, you can force the field to contain 2 decimal places. This would leave the number 12,34 as 1,234.00 which would hopefully show the user that they had a mistake in their input.

1 0
replied on December 7, 2021

It is a number field.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.