Customer Number Format

[Guest]

Hi

I need a customer number format which will display whole numbers with no
decimal points and all other numbers with one decimal place so 6 would be
displayed as 6 and 3.232 would be displayed as 3.2.

Can anyone help with this? Also does anyone know of a good website for
custom number format as I would lile to learn how to use them properly.

TIA

 

[Bob Phillips]

Edgar,

Jason Morin answered the same question a couple of days ago. This is what he
posted

The XL help file actually does a decent job of explaining
formats. Here are some other links to help you:

http://j-walk.com/ss/excel/tips/tip19.htm
(download the file)

http://office.microsoft.com/en-us/assistance/HP051986791033.aspx

http://office.microsoft.com/en-us/assistance/HP052075951033.aspx

watch for wrap-around

--

HTH

RP
(remove nothere from the email address if mailing direct)