Formatting numbers

  • Thread starter Thread starter Prixton
  • Start date Start date
P

Prixton

Hi,
In a column I want all the numbers to end with 000. The figures are coming
from other files and are sometimes with one, two or three 0:s
1230, 12300, 123000
How can I format the cells so that the numbers always come with 000 in
the end? In the example above, what I want is 123000.

Thanks in advance
 
Hi
AFAIK not possible with formats alone. So you'll need a formula in a
separate cell or a VBA solution
 
Thanks Frank,
So I think I solved it by using a macro and testing if none, one, two or
three figures are 0. Then I multiply the original number with 1000, 100, 10
or 0. Now I got the result I wanted.
 

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

Formatting 3
How to programmatically add a non standard custom cell format 12
Custom number format 2
counting records 8
Format a number in a scecial way 8
Converting Phone Numbers 4
Find cell containing a letter 5
Number formatting 4

Back
Top