[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	2,808	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	2,692	Jul-12-2021, 11:09 AM Last Post: jefsummers
	Validating user input	WJSwan	2	2,144	Jul-06-2020, 07:21 AM Last Post: menator01
	Get values from a split column	Pythonito	3	2,113	Apr-18-2020, 11:35 PM Last Post: Larz60+
	Validating the functionality of the application	rpalakodety	1	1,781	Dec-30-2019, 07:58 PM Last Post: ndc85430
	Validating information from .csv file before executemany	mzmingle	7	4,449	Apr-15-2019, 01:40 PM Last Post: mzmingle
	need help with making a validating function	drasil	8	3,758	Mar-28-2019, 10:38 AM Last Post: perfringo
	Validating credit card	frequency	8	4,211	Nov-05-2018, 07:36 PM Last Post: frequency
	Validating Input (basic check for int etc)	gruntfutuk	1	2,492	Aug-06-2018, 07:43 AM Last Post: gruntfutuk
	[split] merge/display values from two dictionaries	ramkumar_70	3	3,690	Oct-17-2017, 09:42 PM Last Post: DeaD_EyE

[split] formula for validating monetary values?

User Panel Messages

Announcements