You need to set the decimal places to zero. You'll find it to the right of
category.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Reen" wrote:

Every time I put a number in a cell such as 1234, it comes out as 12.34 then
I have to format it to text to make it just 1234 and THEN change it to a
number, from the dropdown box that displays itself, I have tried changing the
decimal places and selecting "general" "number", etc. nothing works. Ido
Format cells - number - and in catagory - what do I pick?