Thread: rounding.
View Single Post
  #2   Report Post  
Gary''s Student
 
Posts: n/a
Default

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?