Formatting Numbers to 3 digit,

[Raz]

In a column i have numbers 1 to 999
but I would like to have as 001 to 999, I cannot format as text, becouse
another equation finds the higest number (=max(D)) from this column.
Is there any way, to have the 3 digit format keeping them as numbers?


i.e.
Col D
001
002
003
004

 

[Sean Timmons]

Format Cells

Custom

000

 

[Raz]

thanks, simple but couldnt find it when needed

Format Cells

Custom

000

 

[Sean Timmons]

That's how it always works. Always happy we have this site!