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