#1
|
|||
|
|||
How to format text in a CELL?
Hi,
How can i format CELL text as shown below: Cell A1: 1234567890 Result in Cell B1: 123 456 7890 Thanks. |
#2
|
||||
|
||||
Perhaps =TEXT(A1,"### ### ####")
You can also custom format A1 the same way
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
||||
|
||||
How about =A1 with the number format specified as:
000 000 0000 Indeed, if you specify that number format for A1, you don't even need B1!!
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
Quote:
Thanks a lot for your kind help. Regards. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2007 cell format help!!! | Raner | Excel | 4 | 06-17-2013 11:13 PM |
Cell format not staying | vijer | Excel | 3 | 01-12-2012 07:06 PM |
Cell # format | markg2 | Excel | 4 | 10-23-2011 09:38 PM |
Objective: Automatically export email text,attachment text to DB friendly format | SilentLee | Outlook | 0 | 11-14-2010 02:45 PM |
Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |