dumb formating question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Isaak - 08 Jun 2007 15:05 GMT

I made a spreadsheet, that has a column of $ 12.95 formatted as currancy.
Everything worked great at first, but now every tie I type the decimal
point, excel is inserting 2 spaces between the decimal and the cents, so I
get "$12. 95" instead of "$12.95"

I'm sure this is an obvious problem, but I can't figure it out.

Paul

Signature

__________________________________

The Comedy & Juggling of Paul Isaak
http://www.funnyjuggler.com

Learn to juggle at www.junnyjuggler.com/juggling for free!

Reply to this Message

Dave Peterson - 08 Jun 2007 16:17 GMT

What are you typing into the cell? Do you include the $.

First thing I'd check is the number format.

The next thing I'd check is tools|autocorrect options.
Look to see if the dot is being replaced with a dot followed by two spaces.

> I made a spreadsheet, that has a column of $ 12.95 formatted as currancy.
> Everything worked great at first, but now every tie I type the decimal
[quoted text clipped - 12 lines]
>
> Learn to juggle at www.junnyjuggler.com/juggling for free!

Signature

Dave Peterson

Reply to this Message

Gord Dibben - 08 Jun 2007 20:01 GMT

Paul

Take a look under Format>Style>Currency and see if a modification got made.

Maybe an extra space after the decimal point?

I can replicate that scenario.

Gord Dibben MS Excel MVP

>I made a spreadsheet, that has a column of $ 12.95 formatted as currancy.
>Everything worked great at first, but now every tie I type the decimal
[quoted text clipped - 4 lines]
>
>Paul

Reply to this Message

Rate this thread: