i need a format cell formula that can have some "-" to separate the long number.
example when i key in 0123456789, it will show 012-34-5678-9
thanks
i need a format cell formula that can have some "-" to separate the long number.
example when i key in 0123456789, it will show 012-34-5678-9
thanks
Are the separtations always the same?
3 numbers - 2 numbers - 4 numbers - 1 number
If so,
Please Login or Register to view this content.
HTH
Regards, Jeff
thanks, jeffreybrown,i need a format cell , i have try ###-##-####-#. it show 12-34-5678-9 , the number 0 is gone. it should be have another format cell can make it . please help .
thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks