decimal formatting

A

amyenoch

Is there a way to format cells so that the decimal digits only show if
value other than zero? For instance, if I entered "65" in a cell, i
would show up simply as 65, no decimal point showing. If I changed i
to "65.5"- same cell - then the .5 would show, without having t
physically change the setting. On calculators, it's called floatin
decimal. I checked Help, but didn't see anything like this. Am
missing something??? Thanks for any help
 
P

Peo Sjoblom

Try the default format called General

--
Regards,

Peo Sjoblom

(No private emails please)
 

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

formula for decimal point 4
Access stripping decimal places in query 1
no decimal point if zero 19
Automatically chnage number format of a range of cells 2
Formatting long decimal numbers as TEXT cell, not refreshing? 2
Minus Zero 11
Significant digits 4
Conditional custom number format? 5

Top