엑셀에서 휴대폰번호 한번에 입력하기 #엑셀강의 #excel #셀서식 #직장인 #엑셀팁
Synopsis
엑셀에서 0으로 시작하는 연락처를 깔끔하게 표시하고 싶으신가요? ✨ [셀 서식]-[표시형식]-[사용자 지정]에서 000-0000-0000 형식 ...
You Might Also Like
![[엑셀] 휴대 전화 번호의 '010'과 대시(-)가 자동으로 입력 되도록 하기 / Automatically '010' and '-' in mobile phone numbers](https://i.ytimg.com/vi/sn0hODQHtPg/hq720_2.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGABwAcABBvABAfgBtgiAAoAPigIMCAAQARhcIGUoWzAP&rs=AOn4CLD0PxWePRURhbw4_Ve2_8bwV9ZMiw)
![[엑셀기초] 엑셀에서 휴대폰번호 010 입력하기](https://i.ytimg.com/vi/eyxdT8g9NcQ/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLA9q6jxtVO2jmPxQva0iVw2fNSFcw)
![[Excel] How to enter numbers starting with 0. It couldn't be easier!](https://i.ytimg.com/vi/GOGMxOVDXRw/hq720_2.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGABwAcABBvABAfgBtgiAAoAPigIMCAAQARhlIGUoZTAP&rs=AOn4CLBzLESX3fUk9mLV4bq_7iYw3ywqfg)
![[엑셀 실무]셀 서식을 이용해 핸드폰번호 11,10자리를 입력시 핸드폰 번호 형식으로 변환(010-0000-0000)](https://i.ytimg.com/vi/zjmEvztZLa8/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLAyI3dooMVB-kJLN29KmmwW529KjQ)
![[엑셀] "관리번호-10" 형식의 행 번호 자동 생성하기 Automatically generate row numbers in the format of "No.10" in Excel](https://i.ytimg.com/vi/6mrew57ZVGY/hq720_2.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGABwAcABBvABAfgBtgiAAoAPigIMCAAQARgTIFEofzAP&rs=AOn4CLAjfHA9l0ZwtAKzTTWlm2DaAeb11A)
Download Options
Choose a download method below. All links open in new tabs.
| Service | Features | Action |
|---|---|---|
| Ssvid |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
| SaveFrom |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
Security Notice: These are third-party services. We recommend using antivirus software and being cautious of pop-up ads.