How can I format a column so that when I enter a number it always ends in a specific text?
For example, when I enter certain hours as 4, 5.5, 2, I would like it to always just say "hrs" at the end.
I looked at format cells-->custom, but was not sure where to go from there.
Thanks
Last edited by wmfinance; 08-12-2010 at 04:13 PM.
Hi,
Go to Custom, select 0 then type space "hrs"
0 "hrs"
like so
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Well I had to adjust this minorly, because some of my hours were by halfs. It does work though, thanks for the info and rep has been boosted!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks