Hi. How do you enter 400. into Excel? The important part is to leav
the decimal place after the second zero. I've done everythin
imaginable but the decimal always get erased after I hit enter. Than
you

--
oshirot
-----------------------------------------------------------------------
oshiroty's Profile: http://www.excelforum.com/member.php...fo&userid=1473
View this thread: http://www.excelforum.com/showthread.php?threadid=26352

Format the cell for TEXT before typing the 400. or type a leading
apostrophe, like '400.

The apostrophe will not show up in the cell but will convert the 400. to
TEXT

Vaya con Dios,
Chuck, CABGx3



"oshiroty" <(E-Mail Removed)> wrote in message
news(E-Mail Removed)...
>
> Hi. How do you enter 400. into Excel? The important part is to leave
> the decimal place after the second zero. I've done everything
> imaginable but the decimal always get erased after I hit enter. Thank
> you.
>
>
> --
> oshiroty
> ------------------------------------------------------------------------
> oshiroty's Profile:
http://www.excelforum.com/member.php...o&userid=14733
> View this thread: http://www.excelforum.com/showthread...hreadid=263529
>

You can use a custom number format --

Select the cells in which you'll enter the numbers
Choose Format>Cells
Select the Number tab
Select the Custom category.
In the text box, type: #.#
Click OK

Now, you can type 400 and it will be displayed as 400.


oshiroty wrote:
> Hi. How do you enter 400. into Excel? The important part is to leave
> the decimal place after the second zero. I've done everything
> imaginable but the decimal always get erased after I hit enter. Thank
> you.
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html