custom one digit in a number

[Doug]

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?

 

[Luc]

Doug,
Not in PPT as far as I know. You could use an Excel cell and paste that into
PPT.

 

[eldon.l.lehman]

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

 

[Austin Myers]

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

 

[John Wilson]

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