Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-02-2023, 12:11 AM
AceHeart AceHeart is offline Help in cell format Windows 10 Help in cell format Office 2021
Novice
Help in cell format
 
Join Date: Oct 2023
Posts: 2
AceHeart is on a distinguished road
Question 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
Attached Files
File Type: xlsx Format Adjusted.xlsx (16.9 KB, 3 views)
Reply With Quote
  #2  
Old 10-02-2023, 02:16 AM
AceHeart AceHeart is offline Help in cell format Windows 10 Help in cell format Office 2021
Novice
Help in cell format
 
Join Date: Oct 2023
Posts: 2
AceHeart is on a distinguished road
Talking

It turns out i only need to change the font type to Courier New
Reply With Quote
  #3  
Old 10-02-2023, 02:19 AM
ArviLaanemets ArviLaanemets is offline Help in cell format Windows 8 Help in cell format Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

This isn't formatting feature!
The text is entered into cell using 'Hard Return' - Alt+Enter - to force new rows.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Format Cell-Change Sunil Pinto Excel 3 07-12-2023 10:31 AM
Help in cell format 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft