I wish to fomat numbers in Excel
 

so that 0's follow:if I enter 123 then 123000 will enter.

I wish to fomat numbers in Excel
 

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Rumina" wrote in message
...
so that 0's follow:if I enter 123 then 123000 will enter.

I wish to fomat numbers in Excel
 

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.

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Rumina" wrote in message
...
so that 0's follow:if I enter 123 then 123000 will enter.

I wish to fomat numbers in Excel
 

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.
--
David Biddulph

"Rumina" wrote in message
...
so that 0's follow:if I enter 123 then 123000 will enter.

I wish to fomat numbers in Excel
 

Rumina wrote:
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.

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Rumina" wrote in message
...
so that 0's follow:if I enter 123 then 123000 will enter.


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