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

yvasquez82

New Member

Join Date: Apr 2014

Posts: 1
#1

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

Apr 19 '14, 03:44 PM

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!!!!
Tags: None
Luuk

Recognized Expert Top Contributor

Join Date: Mar 2012

Posts: 1043
#2

Apr 19 '14, 04:14 PM

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

Last edited by Luuk; Apr 19 '14, 04:15 PM. Reason: notice about option 1...
Comment

Comment