Auto Enter a Number into a Cell

[Glenn]

Hello,

I want to format a column of cells to prefix any number I type with 7000. I
tried the custom format of "7000"@ but I get the error checking triangle in
each cell telling me it's text rather than a number.
Is there something I can use in the custom formatting to achieve my goal
other than the "7000"@?

Thank you

 

[Gary''s Student]

"7000"General

 

[Glenn]

Fantastic! Thank you

 

[Dave Peterson]

I would think that you'd want the number you type in to be formatted nicely,
too.

If you type
1
123
12345

you'd want to see something like:
7000001.0
7000123.0
700012345.0

If that's the case you could try a custom format of:
"7000"000.0;-"7000"000.0;"7000"0.0;"7000"@
(positive;negative;0;text)

You may not want that "7000" in front of 0 and text?????

 

[Dave Peterson]

Oops. I messed up the 0's:

"7000"000.0;-"7000"000.0;"7000"000.0;"7000"@

 

[Glenn]

Thanks Dave. Actually, I don't want to see any decimal places.

Oops. I messed up the 0's:

"7000"000.0;-"7000"000.0;"7000"000.0;"7000"@

 

[Dave Peterson]

Then remove them and you'll be set.

Thanks Dave. Actually, I don't want to see any decimal places.