Hanging decimal places with custom number format

S

Sam A

I am having an issue with a hanging decimal. The number format '00 00 00.##'
leaves a decimal even if there isn't a decimal in the number, but '00 00 00'
hides the decimal places all together.

55 55 55 ---> 55 55 55.
55 55 55.66 ---> 55 55 56

I have this problem in both Excel and Access.

Thanks for your help.

Sam
 
T

Tom van Stiphout

On Fri, 17 Apr 2009 06:19:01 -0700, Sam A <Sam
[email protected]> wrote:

I'm seeing nothing wrong here. This is all per the specs. Can you
quote a passage from the help file that contradicts this behavior?

-Tom.
Microsoft Access MVP
 
S

Sam A

It's not technically wrong by the standard that it works exactly how it says
it will, but I want to find a way to get rid of the decimal if there is no
decimal place, but still keep number grouping.

Would this need to be resoved with a macro or function?
 
Top