Hanging decimal places with custom number format

[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

 

[Tom van Stiphout]

On Fri, 17 Apr 2009 06:19:01 -0700, Sam A <Sam
(e-mail address removed)> 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

 

[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?