Use =find(.......) using the search term "."
Sent from my iPhone
On 08/12/2011, at 7:05 PM, "pyeung Yeung" <pyeung1@gmail.com> wrote:
> Paul,
>
> Thanks for your quick reply!
> In your suggestion of sub-problems, I don't know how to determine position
> of decimal point.
>
> On Thu, Dec 8, 2011 at 4:10 PM, Paul Vermeulen <
> paul.vermeulen@vulcantech.com.au> wrote:
>
> > **
> >
> >
> > Iris
> >
> > I see a few sub-problems here.
> >
> > 1) You want the number converted from General Format to Fixed (2
> > decimal places). The issue is that if you tell Excel to display 12 as
> > 12.00, when you convert it to text it reverts back to 12. So, problem
> > two then becomes
> >
> > 2) Determine length of string
> >
> > 3) Determine position of decimal point
> >
> > 4) Calculate number of characters in string between decimal point
> > and end of string.
> >
> > If decimal point not present, add ".00" with concatenate
> > If number = 0, add "00" 'I know this case does not exist.
> > If number = 1, add "0" with concatenate
> >
> > 5) Then you want to add the letter T to the end. You can use
> > concatenate for this.
> >
> > Easy enough to do all this in Excel, and if you record your work with
> > the macro recorder (using fixed and relative references as appropriate)
> > you will get a good starting point for your code.
> >
> > Paul
> >
> > From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
> > Behalf Of Iris
> > Sent: Thursday, 8 December 2011 3:41 PM
> > To: ExcelVBA@yahoogroups.com
> > Subject: [ExcelVBA] Decimal number convert to string
> >
> >
> > How to write a VBA code to convert decimal number to string
> >
> > example:
> >
> > Number String
> > 12 12.00T
> > 12.5 12.50T
> > 12.55 12.55T
> >
> > Thanks in advance!
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar