Column not showing decimal sometimes

R

Rob

I have a column with dollar amounts and most of the time it shows the entire
amount as I entered but a few of them aren't showing the cents for some
reason. When I sum the columns it calculates correctly but I would like to
show the cents when I print.

Also, how can I get it to automatically add the $? One column I have has
amounts in every row and on those it does it automatically but sometimes
other columns don't have a transaction on every row and those I have to type
it each time. Not a big deal but just wondering.
 
S

shakey

Rob said:
I have a column with dollar amounts and most of the time it shows the
entire amount as I entered but a few of them aren't showing the cents for
some reason. When I sum the columns it calculates correctly but I would
like to show the cents when I print.

Also, how can I get it to automatically add the $? One column I have has
amounts in every row and on those it does it automatically but sometimes
other columns don't have a transaction on every row and those I have to
type it each time. Not a big deal but just wondering.
Click to expand...
Guaranteed way
Select a correctly formatted cell from the correctly formatted column then
COPY
Select the entire column that has problems and Paste Special Format.
That should for it to be the same.
SG
 
Top