D
Dawn
Is there a way to make a conditional custom number format? I have two
formats that ALMOST work for what I need, but not quite. #.# works for most
numbers, but if there is no decimal in the number it displays an unnecessary
decimal. ## works for most numbers EXCEPT for ones with a decimal, which it
cuts off on the end. Can I make excel apply #.# to any cell with a decimal
in it and ## to all the rest? Or is there some other custom number format
that will work? Here is a sampling of the numbers I need to display
properly, but all need to have the same format applied to them:
5856792.6
2007-527689
10-2007-7000490
200580022150.1
11/501,207
4704825.1
60/441,759
ABC/US04/01700
I am trying to get around the problem of having numbers alrger tha 12 digits
display in scientific notation. Usually, it would work to change to text
format but ONLY if that's done prior to the number being entered. I am
having to work with a huge report produced from a database which
automatically generates with the "general" format on all the cells. My only
option is to apply a format after the fact, and text format will not
automatically update the display of those 12+ digit numbers. But number
formatting will, if I can just find the right format.
Thanks for any ideas!
formats that ALMOST work for what I need, but not quite. #.# works for most
numbers, but if there is no decimal in the number it displays an unnecessary
decimal. ## works for most numbers EXCEPT for ones with a decimal, which it
cuts off on the end. Can I make excel apply #.# to any cell with a decimal
in it and ## to all the rest? Or is there some other custom number format
that will work? Here is a sampling of the numbers I need to display
properly, but all need to have the same format applied to them:
5856792.6
2007-527689
10-2007-7000490
200580022150.1
11/501,207
4704825.1
60/441,759
ABC/US04/01700
I am trying to get around the problem of having numbers alrger tha 12 digits
display in scientific notation. Usually, it would work to change to text
format but ONLY if that's done prior to the number being entered. I am
having to work with a huge report produced from a database which
automatically generates with the "general" format on all the cells. My only
option is to apply a format after the fact, and text format will not
automatically update the display of those 12+ digit numbers. But number
formatting will, if I can just find the right format.
Thanks for any ideas!