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

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

Top