This basic and a single line codes will demonstrate to you on how to Format in a Currency
form a General Number type like 123456, it will be done like this
Format$("123456","#,##0.00")
So the Output is 123,456.00 it turn into Currency Form
in the Other hand you can Insert a single letter in this format like for example,my Currency
Symbol is P, it look like this
Format$("123456","P #,##0.00")
So the Output is P 123,456.00
Happy Coding
form a General Number type like 123456, it will be done like this
Format$("123456","#,##0.00")
So the Output is 123,456.00 it turn into Currency Form
in the Other hand you can Insert a single letter in this format like for example,my Currency
Symbol is P, it look like this
Format$("123456","P #,##0.00")
So the Output is P 123,456.00
Happy Coding
Leave a comment