Auto Enter a Number into a Cell
 

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

Auto Enter a Number into a Cell
 

"7000"General
--
Gary''s Student - gsnu200902

Auto Enter a Number into a Cell
 

Fantastic! Thank you

"Gary''s Student" wrote:

"7000"General
--
Gary''s Student - gsnu200902

Auto Enter a Number into a Cell
 

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?????



Glenn wrote:

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

--

Dave Peterson

Auto Enter a Number into a Cell
 

Oops. I messed up the 0's:

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

Dave Peterson wrote:

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?????

Glenn wrote:

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

--

Dave Peterson

--

Dave Peterson

Auto Enter a Number into a Cell
 

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

"Dave Peterson" wrote:

Oops. I messed up the 0's:

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

Dave Peterson wrote:

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?????

Glenn wrote:

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

--

Dave Peterson

--

Dave Peterson

Auto Enter a Number into a Cell
 

Then remove them and you'll be set.



Glenn wrote:

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

"Dave Peterson" wrote:

Oops. I messed up the 0's:

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

Dave Peterson wrote:

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?????

Glenn wrote:

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

--

Dave Peterson

--

Dave Peterson


--

Dave Peterson