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.