This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

How to format a number with "-" and "/" and "."

Posted on 06-16-2023 11:24 AM
Sfredoemann
New Member
Reply posted on --/--/---- --:-- AM

Hi i'm quite new in this,
But i'm trying to make this format: 00.000.000/0000-00 and the values should come from my spreadsheet.
Though it comes like this 000.000.000.000 which is not what i want.

0 1 49
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
diogolupcosta
Silver 5
Silver 5
Reply posted on --/--/---- --:-- AM

You need to use some expressions like: MID(), LEFT() RIGHT() and SUBSTITUTE()

0 Likes
Top Labels in this Space