Re: Price Data Formatting

Tech-Archive recommends: Fix windows errors by optimizing your registry


"Webbiz" <noreply@xxxxxxx> wrote in message
news:eQbrcqXAJHA.1184@xxxxxxxxxxxxxxxxxxxxxxx
Hello.

I've created what I consider some pretty novice ways to format my price
data.

But I can't help thinking there is a better way to do this.

For example, suppose I am loading price data that appears to be a decimal
and 4 digits like this (.1234).

The program would need to determine that all results produced from these
values must also have 4 digits after the decimal, even if the answer is
just
.123 or 23.

The .123 should then display as .1230 and the 23 should display as
23.0000,
both cases where 4 digit places exist in the display following the decimal
only because the data loaded appears to be in that form.

I might load data that looks like this:

3.4567
2.3482
5.2849
6.123
1.3847


This tells me that the format I want is a digit prior to the decimal and 4
digits following, even though some of the data loaded actualy had only 3
digits following the decimal. The maximum format from the sample is 1.1234
format. Therefore, I want to format all my resulting calculations in the
same 1.1234 format. Of course the result can be greater than 1 digit left
of
the decimal, but not greater than 4 following in this case.

If my sample data is:

23.45
83.83
22.2
48.89

This tells me I need to format 2 places following the decimal and AT LEAST
2
prior.

What I have been doing now is loading the data and noting the maximum
digits
found right of the decimal and left of the decimal.

How I do this is through a LOOP, using INSTR to find where in the price
string the decimal is located, and using the LEN. But then I have to
figure
out how to make the changes in the Format() to display all my data in that
format discovered, so I create a few Format()'s with "0.0", "0.00",
"0.000",
"#.0000", etc. etc.

This seems pretty hookie to me.

Any suggestions on a better way to do this?

Thanks.

Webbiz


You could use the Currency datatype.
Wrap it in a class that has a format method to return a space terminated
string.

-ralph


.

Relevant Pages

  • Re: Text formatted cells displaying numbers in scientific format
    ... When it 'sees' a large number it uses scientific format since ... I accept that Excel can't handle numbers greater than 15 digits and your ... string was 16 digits or more to be converted to a scientific value. ... It just doesn't display correctly in the cell (except after entering ...
    (microsoft.public.excel)
  • Re: I hate dates
    ... the month as either a number or text string. ... the function requires the year to be four digits long. ... It is not advisable to do this (use two-digit years) as each computer can ... can then format anyway you want or need to using the Format function. ...
    (comp.lang.basic.visual.misc)
  • Re: I hate dates
    ... month as either a number or text string. ... the function requires the year to be four digits long. ... It is not advisable to do this (use two-digit years) as each computer can ... can then format anyway you want or need to using the Format function. ...
    (comp.lang.basic.visual.misc)
  • Re: Parsing dates in files - must need to use SHIFT?
    ... > slash date format with dashes - sounds simple! ... The entire string is replaced - removed the date digits. ...
    (comp.lang.perl.misc)
  • Re: DateTime.ParseExact weird behavior
    ... more inteligent behavior from the parser in this particular case. ... This is a string that is impossible to parse ... format to parse it. ... and as it can be either one or two digits it will read two ...
    (microsoft.public.dotnet.framework)