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