How to "group" numbers?

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Hi.

In my report, I need to format numbers in a way that the numbers get's
divided into "chunks" of 5 numbers starting from the back. Like this:

321654987 vould be formatted like 3216 54987
98765432123456789 would be formatted like 98 76543 21234 56789
123456 would be formatted like 1 23456

Anyone could help me? Jim.
 
Jim said:
In my report, I need to format numbers in a way that the numbers get's
divided into "chunks" of 5 numbers starting from the back. Like this:

321654987 vould be formatted like 3216 54987
98765432123456789 would be formatted like 98 76543 21234 56789
123456 would be formatted like 1 23456
Click to expand...

That big "number" is too large to be stored in a numeric
field. Are you using a text field?

Except for some extra leading spaces, you can format numbers
using a custom format like:
# ##### ##### #####

If it's really a text field, then try using:
@ @@@@@ @@@@@ @@@@@ @@@@@
 
That big "number" is too large to be stored in a numeric
field. Are you using a text field?

Except for some extra leading spaces, you can format numbers
using a custom format like:
# ##### ##### #####

If it's really a text field, then try using:
@ @@@@@ @@@@@ @@@@@ @@@@@
Click to expand...

Thanks Marsh, @ @@@@@ @@@@@ @@@@@ was the thing I was missing. Tried #
##### ##### before. Thanks again, Jim.
 
Back
Top