using decimals points

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Char - 27 Jul 2005 18:16 GMT

I use Excel 2003. I have the default for fixed decimal points set to 2.
When I enter 2345, 23.45 displays. However, when I enter 2345. , I still get
23.45. What I want is 2345.00.

What do I need to do to make this happen?

Char

Reply to this Message

Kassie - 27 Jul 2005 18:56 GMT

Hi Cahr

Have you formatted the cells as Number, 2 fixed decimal points? Or have you
just set the default on the Edit tab under Tools|Options to 2 fixed decimal
points. If the latter, then entering 2345. will display as 2345. If the
first, it will display as 2345.00.

Signature

j.kasselman@atlantic.net.remove_2nd_at. Randburg, Gauteng, South Africa

> I use Excel 2003. I have the default for fixed decimal points set to 2.
> When I enter 2345, 23.45 displays. However, when I enter 2345. , I still get
[quoted text clipped - 3 lines]
>
> Char

Reply to this Message

Dave Peterson - 27 Jul 2005 21:49 GMT

Type 2345.0

xl2003 (IIRC) changed behavior (if you're used to earlier versions)

> I use Excel 2003. I have the default for fixed decimal points set to 2.
> When I enter 2345, 23.45 displays. However, when I enter 2345. , I still get
[quoted text clipped - 3 lines]
>
> Char

Signature

Dave Peterson

Reply to this Message