Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 07:02 PM.


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