Remember Me?

#1
March 7th 06, 04:55 PM posted to microsoft.public.excel.misc
 Aaron1978 Posts: n/a
Setting the number of decimal places for a text box.

Hi All,

I have a user form and on that form is a text box. Data from a cell on
the worksheet is read into that text box and the user can observe it.

A simple calculation is done on the cell before it is read into the
text box. This produces a number with a large number of decimal places.
Even though I set the number of decimal places of that cell to 2 (via
right clicking on the cell and selecting "Format Cells...") the number
read into the text box still displays all the decimal places.

Could anyone tell me how I can set the number of decimal places of the
text box itself?

Best Regards,

Aaron

--
Aaron1978
------------------------------------------------------------------------
Aaron1978's Profile: http://www.excelforum.com/member.php...o&userid=31201

#2
March 7th 06, 05:31 PM posted to microsoft.public.excel.misc
 Henry Posts: n/a
Setting the number of decimal places for a text box.

It will round your result to 2 decimal places.

"Aaron1978" wrote:

Hi All,

I have a user form and on that form is a text box. Data from a cell on
the worksheet is read into that text box and the user can observe it.

A simple calculation is done on the cell before it is read into the
text box. This produces a number with a large number of decimal places.
Even though I set the number of decimal places of that cell to 2 (via
right clicking on the cell and selecting "Format Cells...") the number
read into the text box still displays all the decimal places.

Could anyone tell me how I can set the number of decimal places of the
text box itself?

Best Regards,

Aaron

--
Aaron1978
------------------------------------------------------------------------
Aaron1978's Profile: http://www.excelforum.com/member.php...o&userid=31201

#3
March 8th 06, 08:32 AM posted to microsoft.public.excel.misc
 Aaron1978 Posts: n/a
Setting the number of decimal places for a text box.

Thanks for your reply, but the calculation is done in VBA not in the
cell that the data is read from. Is there a way of rounding numbers in
VBA, I tried but can't seem to find a way.

Best Regards,

Aaron

--
Aaron1978
------------------------------------------------------------------------
Aaron1978's Profile: http://www.excelforum.com/member.php...o&userid=31201

#4
March 8th 06, 04:59 PM posted to microsoft.public.excel.misc
 Jerry W. Lewis Posts: n/a
Setting the number of decimal places for a text box.

Excel 2000 and later has a VBA Round function. It does ASTM rounding (rounds
to nearest rounded value, with ties [exactly 5] rounding up or down to make
an even number).

In earlier versions (or to always round 5 up) you can call the worksheet
Round function from VBA by either
Application.Round()
or
WorksheetFunction.Round()
The former former will work in all versions of Excel that support VBA. I
believe that the latter was introduced in Excel 97, but has the advantage of
prompting you with possible worksheet functions that can be called in this
way.

Jerry

"Aaron1978" wrote:

Thanks for your reply, but the calculation is done in VBA not in the
cell that the data is read from. Is there a way of rounding numbers in
VBA, I tried but can't seem to find a way.

Best Regards,

Aaron

--
Aaron1978
------------------------------------------------------------------------
Aaron1978's Profile: http://www.excelforum.com/member.php...o&userid=31201

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post dmbRedGetta Excel Discussion (Misc queries) 1 September 18th 05 06:58 PM Tim Poulter Excel Discussion (Misc queries) 2 September 18th 05 01:42 AM Rebecca Martinez Excel Worksheet Functions 6 July 7th 05 07:12 PM Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM Dan Excel Discussion (Misc queries) 1 February 23rd 05 10:31 PM

All times are GMT +1. The time now is 01:08 PM.