Cell formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I inherited a large spreadsheet at work/ when I format a column of cells as
Special/Zip Code the result is returning two decimal places 890.15 / I Clear
the formatting but it still returns two decimal places/ is there a master
setting that calculates all entries on entry with decimal places ? ; if so
how does one reset it so there are no decimal places ?
 
You must log in or register to reply here.

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

Access stripping decimal places in query 1
Round a repeating decimal from a formula... 14
Set automatic currancy decimal without entering the decimal? 3
Peculiar Result with SUM 3
Conditional Formatting Formula Not Working 1
Addition errors with Decimal Places 5
CONCATENATE 3
Problem entering numbers 3

Back
Top