SIr if i enter 1 A (one A) in a cell it is showing time as 1:00 AM,,,,, if i enter 1A (without space )it is ok,,,, but i want to enter it as 1 A ( with space)
Please help me
Thanking u
Santhosh
SIr if i enter 1 A (one A) in a cell it is showing time as 1:00 AM,,,,, if i enter 1A (without space )it is ok,,,, but i want to enter it as 1 A ( with space)
Please help me
Thanking u
Santhosh
You can enter it as '1 A or format the cell as Text.
tHANKSFOR UR VALUABLE HELP
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You're welcome. Happy to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks