FORMATTING

G

Guest

When I have to format a cell and I go to format, cell, in the format box my
"general" format has a decimal point in the sample box instead of just a
number ie 1234 looks like 12.34 so when I try to use the general format it
changes all my numbers into decimals.
 
G

Gord Dibben

There is no format box when you select General.

"General format cells have no specific number format"

States that message on the General Dialog.

What are you actually selecting when you go to Cells>Format>Number Tab?


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

Similar Threads

replace using wildcard, or else 3
In Excell 2002-Format cells so last 2 digits go to rite of decimal 1
general formatting numbers in excel 1
formatting negative numbers 1
formatting question 3
Mystical Excel 4
2007: Number format <> Number format 1
Stop XL from changing format? 1

Top