Data format in Excel

New Contributor

I am trying to change formating of  data representing numer of the buliding for instance 4A which has been changed by Excel to 4:00 AM.

2 Replies

Afraid you can't return it back just by formatting. Enter your building numbers as text

- select column/cells where they'll be, Ctrl+1 and apply Text format; or

- add your numbers with ampersand like '4A

Many thanks