general formatting numbers in excel

J

jclausgirl

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

Kevin B

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

Excel does not accept text format! 0
How to count the numbers in a Word document? 0
Cell data entering slow! 0
Table of content - format does not get saved 2
When I insert a worksheet the cell format is accounting 1
Paste to excel from word - auto format problem 1
Remove date format? 3
Can General format numbers be mistaken as text? 6

Top