dumb formating question

P

Paul Isaak

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

--
__________________________________

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

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

Dave Peterson

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top