By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,190 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

How do you get rid of #### in Excel?

P: 1
When I type in 8 AM, #### appears and in the function bar it appears as 8:00:00 AM. How can I make it stay to 8 AM? Please help!!!!
Apr 19 '14 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,035
there are 3 ways:

1) make the column wider
2) in cell properties type the format 'u AM/PM'
3) type a single quoot (') before the text.

wait, option 1 is not what you want if you want to maintain '8 AM'.....
Apr 19 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.