Thread: 4 Digits
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 4 Digits

FormatCellsNumber TabCustom Format of 0000


Gord Dibben MS Excel MVP

On Thu, 28 Jun 2007 11:35:43 -0700, wrote:

I'm trying to formulate a column into 4 digits. So if I were to type
in 25 and hit enter it would show as 0025. Can anyone help me figure
out how to do this? Thanks!