Zero place holders

C

Cheryl Krachkowski

I merged data from Excel. The data is prices that range
from hundreds to ten thousands.

I have used field codes to format the numbers. However
there are zero place holders in front of the the number
equalling the greatest numbers--

For Example: Because 12548.33 is a piece of data, then
982.00 becomes 00982.00.

Please help before I pull out the rest of my hair!
Cheryl
 

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

Similar Threads

challenge with generating a range of sequential numbers 4
Convert Number to Text for Index/Match 1
MultiLevel Lists - converting a placeholder to a field 2
NEED TO FILL BLANK CELLS WITH TEXT STRING 1
NEED TO FILL BLANK CELLS IN DATA WITH TEXT STRING 7
Query to select values after a certain date 0
Leading Zeros; How to Keep ? 2
2 issues really 4

Top