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?

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?

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?
|
|
|
|

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?
|
|
|
|

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?
| |
| |
| |
| |
|
|
|
|

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?
| |
| |
| |
| |
|
|
|
|

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







"Roger Govier" wrote in message ...
| 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?
| | |
| | |
| | |
| | |
| |
| |
| |
| |
|
|