| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Enter a Number into a Cell
"7000"General
-- Gary''s Student - gsnu200902 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Enter a Number into a Cell
Fantastic! Thank you
"Gary''s Student" wrote: "7000"General -- Gary''s Student - gsnu200902 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto enter date when another cell populated? | New Users to Excel | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| i want cells to auto fill with colour when i enter a number | Excel Discussion (Misc queries) | |||
| How to auto-enter date when cell is clicked? | Excel Discussion (Misc queries) | |||
| auto enter cell info like lotus | Setting up and Configuration of Excel | |||
Linear Mode
