100 to 100'000

[fypo]

Hi All,

Thanks for your attention.
I would like any number that is entered into cell A1 to be multiplied by 1000 by default.

So if I type in 150, I get 150'000.

Any help would be very helpful.

Thanks,
fypo

[kbkumar]

You would need vba to get this done...Try something like this:

Please Login or Register  to view this content.

[fypo]

Hi,
VBA is beyond my abilities tbh. Custom formatting looks like it might work, just can't work out what the %%% ### correspond to. What do you think?

[kbkumar]

I dont think thats possible using number formats...

[MrShorty]

If this were me, I'd use a helper column. I know, our tendency is to treat cells/columns like they are extremely valuable, so we don't want to use too many of them. The thing we have to remember is that we have millions of cells at our disposal, and memory and processor power are cheap, so they really aren't very valuable. If you are entering data in column A, a simple formula like =A1*1000 copied down will have the desired effect. It can even be nested inside of an IF() function if you want to return blanks instead of 0 until an entry is entered into a cell.

[fypo]

If this were me, I'd use a helper column. I know, our tendency is to treat cells/columns like they are extremely valuable, so we don't want to use too many of them. The thing we have to remember is that we have millions of cells at our disposal, and memory and processor power are cheap, so they really aren't very valuable. If you are entering data in column A, a simple formula like =A1*1000 copied down will have the desired effect. It can even be nested inside of an IF() function if you want to return blanks instead of 0 until an entry is entered into a cell.

I just think it seems like a simple thing, so it must be possible.
I agree with your point about the sheer number of cells, but I like to use as few cells as possible - mostly for the challenge and robustness.