| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to type 0010 at excel?
it always converts to 10 when i type 0010 . .
how to change the setting ? ? ? some excel pro please help me ! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to type 0010 at excel?
Format the cell to "Custom"
Custom "Type" should be 0000 "Ch3misTry" wrote: it always converts to 10 when i type 0010 . . how to change the setting ? ? ? some excel pro please help me ! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to type 0010 at excel?
it always converts to 10 when i type 0010 . .
Another way, if you don't mind it as text, is to either precede the input with an apostrophe ('), or perhaps easier, just pre-format the data entry range as: Text -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert date type to text type | Excel Discussion (Misc queries) | |||
| Excel will not let me type any characters....I can type in Word. | Excel Discussion (Misc queries) | |||
| Excel will not let me type any characters....I can type in Word. | Excel Discussion (Misc queries) | |||
| how to change all the words of one type(Gunsuh type)to another | Excel Discussion (Misc queries) | |||
| Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) | |||
Hybrid Mode
