Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula help
Hello,
I'm looking for some help in creating a formula which will add "days" at the end of the number I put in the column. As a drop down list would be too cumbersome due to the amount of entries that exceed 500-1000 days (scrolling would take time for every field), I'd like to know if there's a way to automatically add the "days" so that we don't constantly have to type it in. Thanx S. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula help
Format Cells... Number Custom
General" days" will not only put days at the end of the number, you can still use the number in formulae -- Gary's Student gsnu200703 "srain001" wrote: Hello, I'm looking for some help in creating a formula which will add "days" at the end of the number I put in the column. As a drop down list would be too cumbersome due to the amount of entries that exceed 500-1000 days (scrolling would take time for every field), I'd like to know if there's a way to automatically add the "days" so that we don't constantly have to type it in. Thanx S. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |