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

[split] formula for validating monetary values?

User Panel Messages

Announcements