I wish to fomat numbers in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
I think you would need VBA but here is a work around for a one-time entry.
Enter the numbers
Type 1000 in an empty cell
Copy that cell
Select the range of numbers and use Paste Special, specify Multiply
Delete the 1000
best wishes
 
Either I need more step-by-step instructions (the 0's are infront) or it is
not working. I need it for a template.

Thank you for trying.
 
If you actually want to change the number on entry, rather than format the
number as mentioned in your subject line, then you could use Tools/ Options/
Edit/ Fixed decimal places: Set to -3, but you'll need to remember to put
it back to normal afterwards.
 
Rumina said:
Either I need more step-by-step instructions (the 0's are infront) or it is
not working. I need it for a template.

Thank you for trying.
Click to expand...

Rumina,

The zeroes are in front? Like "000123" ? Then format/cells/custom ######
But if the zeroes are trailing, like "123000", then format/cells/custom/
###"000"

?

Beege
 
You must log in or register to reply here.

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

How to programmatically add a non standard custom cell format 12
how do I get a function formula cell to format as a number? 5
Formatting numbers 2
Alt codes 4
More help needed :-( 5
Custom number format 2
Apostrophe Infront of Text & Numbers 1
Cell Format 1

Back
Top