#1
|
|||
|
|||
Help in cell format
I have an excel file given by my friend. But what make me curious is the way the data in each cell when "Wrap Text" is on is positioned neatly like the file attached. I've tried to see the format setting, but it was set to General with a lot of # appear.
Does anyone here know to do this format effect?? Thank you for your response and help |
#2
|
|||
|
|||
It turns out i only need to change the font type to Courier New
|
#3
|
|||
|
|||
This isn't formatting feature!
The text is entered into cell using 'Hard Return' - Alt+Enter - to force new rows. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Format Cell-Change | Sunil Pinto | Excel | 3 | 07-12-2023 10:31 AM |
Need formula to format one cell if another cell includes specific text | Bigsur2 | Excel | 2 | 11-17-2022 11:53 AM |
Format a cell in a table | DJ0691 | Excel | 3 | 01-21-2020 02:50 PM |
How to format text in a CELL? | Learner7 | Excel | 3 | 08-06-2012 03:52 AM |
Cell # format | markg2 | Excel | 4 | 10-23-2011 09:38 PM |