Software

Ask something
Discussion Locked

excel format text box

0 helpful
5 replies

by hotrodgers

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i am using this formula in my text box:
=EMBED("Forms.TextBox.1","") and i am getting 12 decimal places ex: 260.416666666667 how can i format this to let me have only 1 decimal place in the text box? thanks
steve

5 replies

by kernow_boy

Right click on the cell and click format cells, click on the number tag, then select numbers from the list shown, to the right is a box with the number of decimal places, simple alter this number to the of decimal places you want.

hope this helps

by hotrodgers

you cannot right click and format a text box like a regular cell...i know how to do it that way but cannot figure out how to do it for a text box...thanks for the suggestion

by nik_cert

One could try the VBA formatnumber , this would define the number to the type required
ie use ###.# would produce a rounded up single decimal placed number

This discussion is closed to new replies.