Custom Number Formatting

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

Guest

I am trying to set up a custom number format. I need it to be able to show
one decimal place, but only if there is a decimal in the data I enter. I
would use the standard format except that I want to have "lbs" after the
figure.

I've used "# 'lbs'" and "#.# 'lbs'" but they don't give me what I want. The
first will round off data with a decimal, and the second will place a decimal
after the number even if there is no decimal in the data entered. I need a
single format that when "75" and "87.5" are entered, it will yeild "75 lbs"
and "87.5 lbs" respectively.
 
I have run into another problem with the custom number formatting. Same basic
idea as the original post, except the data being entered comes from a formula
and sometimes has a infinite decimal. I have tried using "##.##°" as the
format, but when the figure is an even number, it places a decimal after the
number- I want to avoid that if possible. How would I do it?
 
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

Excel Excel 2007 won't stop rounding down my formula results! 5
Decimal Place goes crazy when using the "&" Sign. 4
Dynamic Custom Number Format 2
adding lbs & oz's 4
Pricing decreases as quantity increases- how to do that 2
adding digits with moving decimals 3
Adding numerals with moving decimals 2
Formatting within a formula 5

Back
Top