View Single Post
 
Old 02-25-2020, 01:48 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by ArviLaanemets View Post
Like
Code:
=TEXT(A1,"00-0000-00000")
This simple? My experiments went to LEFT, RIGHT, LEN.... etc. This is the solution to my other problem of joining a data in percentage format with a text.
Thank you Arvi.
Reply With Quote