View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default type a 00 . It keeps changing back to 0

Pre-format the cells as Text or precede the 00 with an apostrophe.

Same for 01

Alternative.......custom format of 00 then just enter 0 or 1


Gord Dibben MS Excel MVP

On Sat, 2 Jun 2007 11:13:00 -0700, how do i type a double 0 <how do i type a
double wrote:

I am trying to do a flow chart on a racing contest we have in a group and
everytime i type 00 it changes it back to 0 or if i type 01 it changes it to
1.