formula help

G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top