Cell format to show integers and decimals

  • Thread starter Thread starter onedaywhen
  • Start date Start date
O

onedaywhen

My original idea didn't work, can *this* be done with a cell
numberformat? I want to display numbers with two decimal places unless
the number is an integer i.e.

876 is displayed as 876
234.56 is diplayed as 234.56

Is it possible?
 
onedaywhen said:
My original idea didn't work, can *this* be done with a cell
numberformat? I want to display numbers with two decimal places unless
the number is an integer i.e.

876 is displayed as 876
234.56 is diplayed as 234.56

Is it possible?
Click to expand...

No.
 
Thanks, Andy. Sometimes the most obvious thing can be hardest to see!
 
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

How to retrieve number of visible digits after decimal point in VBA 5
Decimal Tab Characters 7
Access stripping decimal places in query 1
Zeros after the decimal 7
extract decimal and convert to integer 9
Your entry cannot be used. An integer or decimal number may be req 3
formatting question 3
Decimal point in bar chart and similar 1

Back
Top