Store numbers starting with zero as 2 digit numbers
The cell is now displaying the number as 05 but the formula bar shows it is
still 5 so when it is uploaded into another system only the single digit will
carry through
"Gary''s Student" wrote:
Format Cells.. Number Custom and then 00
--
Gary's Student
"twisted1825" wrote:
I need to hard code a single digit number (such as 5) as a 2 digit number
(05). Any ideas?
|