Hello, have an 8 digit number in one cell. EX: 32174741. for easy reading, would like to add a space after the first three digits and a space prior to the last digit. to look like 321 7474 1 Is this possible? many thanks to everyone. esuz
You could custom format your cell using this format pattern...
### #### #
NOTE: Please mark the message or messages (yes, you can mark more than one) that answer your question as the "Answer" so that others will know your question has been resolved.
*** PLEASE READ ***
If this response answers your question, please mark it as the "Answer".
41 people found this reply helpful
·
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.