Home

Data format in Excel

Highlighted
Iza19
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
Highlighted

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

Highlighted

Many thanks

Related Conversations
Creating Pie charts.......
dougler2020 in Excel on
2 Replies
How to use the trendline to find percentage change?
fishfish31 in Excel on
0 Replies
tableau
Noemie911 in Excel on
4 Replies
Summarzing data
Ravi_Kumar in Excel on
1 Replies