Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating fixed information in a cell
Can anyone help me figure out how to keep a "fixed" word in a cell but add
information? For instance; I have a cell that says "From:" I would like to keep that word fixed and be able to type a date after it without having to retype From then the date. Is there a cure? Any help would be great! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating fixed information in a cell
Hi Kay,
="From: "&a2 assuming the date is in A2 hth regards from Brazil Marcelo "Kay" escreveu: Can anyone help me figure out how to keep a "fixed" word in a cell but add information? For instance; I have a cell that says "From:" I would like to keep that word fixed and be able to type a date after it without having to retype From then the date. Is there a cure? Any help would be great! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating fixed information in a cell
Use a custom format like this
"From:" @ when you type in something like "test" in the cell it will look like this Form: test "Kay" wrote: Can anyone help me figure out how to keep a "fixed" word in a cell but add information? For instance; I have a cell that says "From:" I would like to keep that word fixed and be able to type a date after it without having to retype From then the date. Is there a cure? Any help would be great! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating fixed information in a cell
If you want to use a different cell:
="From: " & text(a1,"mm/dd/yyyy") If you want to use the same cell, give it a custom format of: "From: " mm/dd/yyyy The nice thing about the second choice is that the value in the cell is still a date--even though you see "From: " in the cell in the worksheet (but not in the formula bar!). Kay wrote: Can anyone help me figure out how to keep a "fixed" word in a cell but add information? For instance; I have a cell that says "From:" I would like to keep that word fixed and be able to type a date after it without having to retype From then the date. Is there a cure? Any help would be great! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Can you have fixed cell reference when dragging/copying formulae? | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Help creating single cell Pop-up | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |