R
Rumina
so that 0's follow:if I enter 123 then 123000 will enter.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
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
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
R
Rumina
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.
not working. I need it for a template.
Thank you for trying.
D
David Biddulph
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.
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.
B
Beege
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.
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