 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General PowerPoint Questions / June 2006custom one digit in a number
Is there any way to customize only one digit is a number? For example: take the number 4.2831 I want the 831 to dissapear and the 2 to change to a three. Any help? Doug, Not in PPT as far as I know. You could use an Excel cell and paste that into PPT.  SignatureLuc Sanders (MVP - PowerPoint) > Is there any way to customize only one digit is a number? > For example: take the number 4.2831 > I want the 831 to dissapear and the 2 to change to a three. > > Any help? > Is there any way to customize only one digit is a number? > For example: take the number 4.2831 > I want the 831 to dissapear and the 2 to change to a three. > > Any help? Hello Doug, One approach could be to format it with VBA. -----start code---- Public Sub RoundDigit() With ActivePresentation.Slides(1).Shapes(2).TextFrame .TextRange = "4.2831" .TextRange = Format(.TextRange, "##.#") End With End Sub -----end code---- This addresses the specific example, but modifications could be made to take care of the rounding for other place values. Any help? Very helpful - round to the ten thousandths place Somewhat helpful - round to the thousandths place Not real helpful - round to the hundredths place Really awful - round to the tenths place 4 . 2 8 3 1 Eldon Further to the above vba here are two more macros that may help The first works in edit view and resets all text boxes to format required The second works in slide show view (call from button / action setting) and sets the current slide to the one decimal place format Signature----------------------------------------- Did that answer the question / help? _____________________________ John Wilson Microsoft Certified Office Specialist > > Is there any way to customize only one digit is a number? > > For example: take the number 4.2831 [quoted text clipped - 23 lines] > > Eldon Well, you can fake it. Create a text box with 3 in it, create another text box with 4.2831 in it and set it to disappear (Exit animation) when clicked. Now drag the text box with 4.2831 and place it "on top" of the other text box. Yer good to go. Austin Myers MS PowerPoint MVP Team Provider of PFCMedia http://www.pfcmedia.com > Is there any way to customize only one digit is a number? > For example: take the number 4.2831 > I want the 831 to dissapear and the 2 to change to a three. > > Any help? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.