View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
twisted1825 twisted1825 is offline
external usenet poster
 
Posts: 5
Default 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?