insert a space in between numbers

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
Answer
Answer

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.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated May 23, 2024 Views 16,571 Applies to: