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. |
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. |
All times are GMT +1. The time now is 01:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com