Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
type a 00 . It keeps changing back to 0
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
type a 00 . It keeps changing back to 0
Hi,
Custom formats are added by choosing Format, Cells, Number tab, Custom and editing the Type line, in this case to read 00. To apply the format to another cell you can use the Format Painter, the Edit, Paste Special, Format command or you will fine it under Format, Cells, Number tab, Custom at the very bottom of the list. Warning - custom formats belong to the workbook not Excel so they need to be created fresh in each workbook or added to the default workbook. -- Cheers, Shane Devenshire "how do i type a double 0" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display date as 06/08 (m,yy) without year changing back to 07? | Excel Discussion (Misc queries) | |||
I type NWO and it becomes NOW How can I keep NWO from changing? | Excel Discussion (Misc queries) | |||
Changing a date back one month | Excel Discussion (Misc queries) | |||
Web-type Back and Forward navigation between Excel worksheets | Excel Worksheet Functions | |||
Hyperlink - execute a "Back/Previous" type of functionality | Excel Discussion (Misc queries) |