ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Format (https://www.excelbanter.com/new-users-excel/21881-format.html)

Rashed

Format
 
How can I format 2392617177 to 239-261-7177? Please help

Don Guillett

formatcustomformat000-000-0000

--
Don Guillett
SalesAid Software

"Rashed" wrote in message
...
How can I format 2392617177 to 239-261-7177? Please help




Rashed

I tried to follow but it didnt work. I have large quantity data in this
format 2392617177, I would like to put in this format 239-261-7177. How can I
do it? Thanks

"Don Guillett" wrote:

formatcustomformat000-000-0000

--
Don Guillett
SalesAid Software

"Rashed" wrote in message
...
How can I format 2392617177 to 239-261-7177? Please help





Rashed

Thanks...it work.........thank you very much. It save my lots of time. Thank
you Don Guillett.

"Don Guillett" wrote:

formatcustomformat000-000-0000

--
Don Guillett
SalesAid Software

"Rashed" wrote in message
...
How can I format 2392617177 to 239-261-7177? Please help





Don Guillett

glad to help

--
Don Guillett
SalesAid Software

"Rashed" wrote in message
...
Thanks...it work.........thank you very much. It save my lots of time.

Thank
you Don Guillett.

"Don Guillett" wrote:

formatcustomformat000-000-0000

--
Don Guillett
SalesAid Software

"Rashed" wrote in message
...
How can I format 2392617177 to 239-261-7177? Please help








All times are GMT +1. The time now is 09:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com