Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-11-2014, 02:42 AM
Scaffold Scaffold is offline Make text value in a cell appear in parentheses Windows 7 64bit Make text value in a cell appear in parentheses Office 2013
Advanced Beginner
Make text value in a cell appear in parentheses
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 36
Scaffold is on a distinguished road
Default Make text value in a cell appear in parentheses


Greetings all!

My question I believe is a simple one, but I could not get it to work myself.
I need text value in a cell to appear in parentheses.
For example, if I enter 357 in a cell, it should appear there as "357".
Obviously something to do with cell format... Can you help me?
Reply With Quote
  #2  
Old 08-11-2014, 10:19 AM
gebobs gebobs is offline Make text value in a cell appear in parentheses Windows 7 64bit Make text value in a cell appear in parentheses Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

I think you mean double-quotes, not parentheses. Parentheses would be easy. Even single-quotes can be done. To do that, set the custom format for the cells to "'"#"'" (i.e. double-quote,single-quote,double-quote on either side of the #). This will format 357 as '357'.

I tried to do it similarly for double-quotes, but it didn't work.
Reply With Quote
  #3  
Old 08-11-2014, 11:19 PM
Scaffold Scaffold is offline Make text value in a cell appear in parentheses Windows 7 64bit Make text value in a cell appear in parentheses Office 2013
Advanced Beginner
Make text value in a cell appear in parentheses
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 36
Scaffold is on a distinguished road
Default

Yes, I mean double-quotes. Sorry! The English is my second language.

Well, but I really need double-quotes not single-quotes. The application I intend to use this spreadsheet for requres double-quotes! Any ideas?
Reply With Quote
  #4  
Old 08-12-2014, 03:59 AM
gebobs gebobs is offline Make text value in a cell appear in parentheses Windows 7 64bit Make text value in a cell appear in parentheses Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Figured it out!

Use the custom format: \"#\"
Reply With Quote
  #5  
Old 08-13-2014, 06:26 AM
Scaffold Scaffold is offline Make text value in a cell appear in parentheses Windows 7 64bit Make text value in a cell appear in parentheses Office 2013
Advanced Beginner
Make text value in a cell appear in parentheses
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 36
Scaffold is on a distinguished road
Default

Hi!

It works, but only for figures - not for text. If I enter 100, it shows it as "100", but if I enter "hundred", it remains as hundred.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Make text value in a cell appear in parentheses Insert parentheses before and after each word in a file. Singh_Edm Word VBA 9 11-19-2015 09:25 PM
Make text value in a cell appear in parentheses Make Cells Mimic The Formatting Of One Cell skoz55 Excel 1 11-09-2011 09:00 AM
Make text value in a cell appear in parentheses Parentheses Changing on Document Subject1157 Word 2 06-16-2011 08:46 PM
How can I make a cell color RED under the Today's date cell? Learner7 Excel 2 07-08-2010 12:52 AM
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 02:39 PM.


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