custom one digit in a number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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?
Click to expand...

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
 
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
 
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
--
-----------------------------------------
Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
 
Back
Top