Hi all,

Hoping someone can guide me, I am trying to figure out a way to automatically reform a whole number into a second-place decimal.

e.g. 1423 would format to 14.23, 2342342 to 23423.42, or 243400 would be 2434.00

I have tried formulas I found online, but they all seem to add the two leading zeros rather than move the decimal point to the left.

Thanks

Edited 1 hour ago1 hr by JMart

What is the context of your question?

Your examples do NOT "format" a number; they divide it by 100 (at least I think that's what they were meant to do: I see no way that "1423 would format to 12.43").

However, the result of division is a number - and numbers do not carry trailing zeros after the decimal point. For this you would have to either format the field to display as decimal or do it yourself and make the result type Text (hence my question about the context).

Thank you for the reply. My apologies for the typo.

If a user enters 1243 in a number field, the value would change to 12.43 when the field is exited. In other words, automatically format the value by placing the decimal two digits to the left of the entered value.

Thanks

Rudy

5 minutes ago, JMart said:

If a user enters 1243 in a number field, the value would change to 12.43 when the field is exited

Again, that's not a matter of formatting. Those are two entirely different numbers. A simple way to get the behavior you described is to define the field to auto-enter a calculated value (replacing existing value) of:

Self / 100

But that could pose a problem when the user wants to edit an already processed value.

Thanks, this works perfectly for the intended purpose. I was using a function. As per the user editing existing values, this particular field cannot and will never be edited once the record is created.

Thanks

Rudy