general formatting numbers in excel

G

Guest

When I try to format a cell with the general formatting Excel inserts a
decimal point.
When I open the format box the general format shows an existing decimal
point and I can't get rid of it.
 
G

Guest

Instead of selecting GENERAL as the format, select NUMBER and set the number
of decimal place to display to 0.
 

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

formatting negative numbers 1
General Format altered/corrupted? 1
FORMATTING 1
Stop XL from changing format? 1
Can General format numbers be mistaken as text? 6
CELL FORMAT 6
how do I make Excel default to General number format? 2
Decimal Numbers typed into Excel 2003 read as whole numbers 1

Top