[split] formula for validating monetary values?

kakos_k9 · (This post was last modified: Dec-17-2022, 07:13 PM by Yoriz.)

Hello how are you? Could you show me what is the formula for validating monetary values? for example I enter: 1000
it converts to:
1,000.00
The point is because I'm in Brazil

Yoriz write Dec-17-2022, 07:13 PM:
Please do not create your new question on a random old thread, create your own new thread.

woooee · Dec-17-2022, 09:28 PM

Look up string formatting. Note that 1000 and 1,000.00 are the same number, they are just formatted differently.

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	How to split file by same values from column from imported CSV file?	Paqqno	5	5,680	Mar-24-2022, 05:25 PM Last Post: Paqqno
	Python “Formula” Package: How do I parse Excel formula with a range of cells?	JaneTan	1	3,571	Jul-12-2021, 11:09 AM Last Post: jefsummers
	Validating user input	WJSwan	2	2,929	Jul-06-2020, 07:21 AM Last Post: menator01
	Get values from a split column	Pythonito	3	2,945	Apr-18-2020, 11:35 PM Last Post: Larz60+
	Validating the functionality of the application	rpalakodety	1	2,391	Dec-30-2019, 07:58 PM Last Post: ndc85430
	Validating information from .csv file before executemany	mzmingle	7	6,825	Apr-15-2019, 01:40 PM Last Post: mzmingle
	need help with making a validating function	drasil	8	5,231	Mar-28-2019, 10:38 AM Last Post: perfringo
	Validating credit card	frequency	8	5,506	Nov-05-2018, 07:36 PM Last Post: frequency
	Validating Input (basic check for int etc)	gruntfutuk	1	3,123	Aug-06-2018, 07:43 AM Last Post: gruntfutuk
	[split] merge/display values from two dictionaries	ramkumar_70	3	4,497	Oct-17-2017, 09:42 PM Last Post: DeaD_EyE

[split] formula for validating monetary values?

User Panel Messages

Announcements