Same here, even if I modify the digit grouping symbol in the Control
PanelRegional and Language Options. It was only after trying all sorts of
formatting switches that I resorted to creating the macro.
Wait a minute, it does work if you use Ctrl+Shift+Spacebar to insert the
space in the formatting switch
# ##0.0
Also, the switch shown above is all that is required no matter how many
digits are contained in the number
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Graham Mayor" wrote in message
...
How odd - here I get 12 3.45 in both Word 2003 and 2007 using that
switch?
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
macropod wrote:
Hi Graham,
Works for me - 12345 gets displayed as 12 345.00, which accords with
the OP's requirement (I always require two decimal places, even if
the user only inputs the integer value).
"Graham Mayor" wrote in message
...
You could do that but you are reliant on the user entering the
decimal. Try it with 12345 --
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
macropod wrote:
Hi Owen,
If you make the formfield type numeric, you can specify the number
format as: ### ### ##0.00
"Owen" wrote in message
...
I am attempting to determine the format code i need to enter in a
numeric form field.
The following are my parameters:
The format i am trying to achieve is:
### ### ###.##
I always require two decimal places, even if the user only inputs
the integer value.
I require a space between each 3 consecutive digits.
I do not want to show any leading zeros.
For example, the formatted fields appear as
456 345.23
2 456 345.23
Thanks in advance for any help, i do not seem to be able to achieve
the desired result through using # or 0 or any combination of them.