Thank you kindly Roger,
semantics bah
I am still tickled this "rounding" works for my application.
but I understand your point.
rodney at touch88.com.au
(e-mail address removed)
| Hi Rodney
|
| I don't think Bernard was suggesting this wouldn't work, he was perhaps
| questioning the terminology.
| He was merely pointing out that what you are doing is not "rounding". You
| are setting the number of digits displayed for a number, which is quite
| different to rounding. With rounding, you would be saying that you wanted
| all numbers rounded to the nearest 50, or whatever, when 46, 47 48 etc.
| would be displayed as 50.
|
| Gary's suggestion does exactly what you require.
|
| Regards
|
| Roger Govier
|
|
| Rodney wrote:
| > G'day Bernard,
| > I note your raised voice in the "heads up".
| > Would you care to explain, how this differs
| > and any hurdles I may encounter?
| >
| > I have not had the time to place the advice into practice
| > but on a test run it seemed to work fine.
| > I am concatenating the "rounded or triple digit result"
| > to a text precursor so as to enable a VLookup function
| > in ascending order.
| > Without the rounding effect of the triple digit
| > the concatenated list falls out of asc or des order.
| > The lookup table is 55,000 long and it tends to grind
| > I was assuming a neatly ordered list would speed things a little.
| >
| > Best Regards
| > Rodney.
| >
| >
| > --
| > rodney at touch88.com.au
| >
| > Send spam to the FTC at
| > (e-mail address removed)
| > Thanks, robots.
| >
| >
| >
| > | Please note this is NOT "rounding"
| > | best wishes
| > | --
| > | Bernard V Liengme
| > |
www.stfx.ca/people/bliengme
| > | remove caps from email
| > |
| > | | > | > Thanks GS,
| > | > indeed it does,
| > | > mind boggling in its simplicity
| > | >
| > | > (e-mail address removed)
| > | >
| > | >
| > | >
| > | >
| > | >
| > | > message
| > | > | > | > | click on the cell(s) then pull-down:
| > | > |
| > | > | Format > Cells... > Number > Custom
| > | > | backspace out general and enter 000
| > | > |
| > | > | The number will always have three digits with leading zeros as
| > | > necessary.
| > | > |
| > | > | Have a good day
| > | > | --
| > | > | Gary''s Student
| > | > |
| > | > |
| > | > | "Rodney" wrote:
| > | > |
| > | > | > G'day Trendsetters,
| > | > | > I seek to round up numbers and part numbers
| > | > | > to 800, with the round up result showing a three digit read out.
| > | > | > eg: 1 as 001, 56 as 056, 750 as 750.
| > | > | > any legerdemain available?
| > | > | >
| > | > | >
| > | > | >
| > | > | >
| > | >
| > | >
| > |
| > |
| >
| >
