| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to transform float to percentages within an array?
Hi newsgroup,
I produced an array containing floaters between 0 and 1 calculated as a percentage, e.g. 0,8888788888. If I try to use them as the Text of a Text Box, this Box shows the floater but I need to show the percentage in the format "88,88 %". Do you know how I can transform these array entries to the format needed? Thanks in advance and best regards, Markus |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to transform float to percentages within an array?
Textbox1.Text = Replace(Format(varr(i,"#0.00 %"),".",",")
-- Regards, Tom Ogilvy "Markus Scheible" wrote in message ... Hi newsgroup, I produced an array containing floaters between 0 and 1 calculated as a percentage, e.g. 0,8888788888. If I try to use them as the Text of a Text Box, this Box shows the floater but I need to show the percentage in the format "88,88 %". Do you know how I can transform these array entries to the format needed? Thanks in advance and best regards, Markus |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to transform float to percentages within an array?
you can transform most text by using the format method
fl = 0.888887888888 flstr = Str(fl) finstr = Format(flstr, "##.00 %") MsgBox finstr "Markus Scheible" wrote: Hi newsgroup, I produced an array containing floaters between 0 and 1 calculated as a percentage, e.g. 0,8888788888. If I try to use them as the Text of a Text Box, this Box shows the floater but I need to show the percentage in the format "88,88 %". Do you know how I can transform these array entries to the format needed? Thanks in advance and best regards, Markus |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to transform float to percentages within an array?
Hi Tom, hi Ben,
thanks a lot for the tip. Now it works perfectly... Best Markus -----Original Message----- Textbox1.Text = Replace(Format(varr(i,"#0.00 %"),".",",") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Have a text box 'float' over a sheet | Excel Discussion (Misc queries) | |||
| menu float | Excel Discussion (Misc queries) | |||
| How do I float a clipart object | Excel Discussion (Misc queries) | |||
| Need field at top to float down as I scroll down? | Excel Worksheet Functions | |||
| How do I float cells so others scroll under it? | Excel Discussion (Misc queries) | |||
![Markus Scheible[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
