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
Thanks, robots.
"Bernard Liengme" wrote in message ...
| Please note this is NOT "rounding"
| best wishes
| --
| Bernard V Liengme
| www.stfx.ca/people/bliengme
| remove caps from email
|
| "Rodney" wrote in message
| ...
| Thanks GS,
| indeed it does,
| mind boggling in its simplicity :)
|
|
|
|
|
|
|
| "Gary''s Student" wrote in
| 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?
| |
| |
| |
| |
|
|
|
|