| 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 |
| 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 | |||
Threaded Mode
