Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-05-2012, 04:11 AM
Learner7 Learner7 is offline How to format text in a CELL? Windows XP How to format text in a CELL? Office 2007
Advanced Beginner
How to format text in a CELL?
 
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 08-05-2012, 11:32 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to format text in a CELL? Windows 7 64bit How to format text in a CELL? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 08-05-2012, 05:08 PM
macropod's Avatar
macropod macropod is offline How to format text in a CELL? Windows 7 64bit How to format text in a CELL? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #4  
Old 08-06-2012, 03:52 AM
Learner7 Learner7 is offline How to format text in a CELL? Windows XP How to format text in a CELL? Office 2007
Advanced Beginner
How to format text in a CELL?
 
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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!!

Thanks a lot for your kind help.

Regards.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to format text in a CELL? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft