Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 4
Question Wrapping a formatted date

Hi,
I have a large spreadsheet with the day of the week and corresponding date in one cell, for instance, "Monday 9/3". I'd like it to wrap in the cell where Monday is on one line and 9/3 is centered below it in the same cell. Of course I could do it manually, but I'm creating weekday calendars from now until July and I don't want to take that time.
Can anyone help?
Thanks,
Anne
  #2   Report Post  
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by ASJassie View Post
Hi,
I have a large spreadsheet with the day of the week and corresponding date in one cell, for instance, "Monday 9/3". I'd like it to wrap in the cell where Monday is on one line and 9/3 is centered below it in the same cell. Of course I could do it manually, but I'm creating weekday calendars from now until July and I don't want to take that time.
Can anyone help?
Thanks,
Anne
Hi Anne,

1) Select all the cells you need this done to.
2) Press Ctrl+H to bring up the find and replace box
3) In the "Find What" box just enter a space
4) In the "Replace With" box hold down the Alt key (the one to the left of the space bar) and type 0010 on the numeric keypad (not the numbers along the top of your keyboard)
5) Nothing will show in the replace with box, but the magic will happen as soon as you hit the "Replace All" button.

Let me know if that works or not for you. :)
  #3   Report Post  
Junior Member
 
Posts: 4
Default

Quote:
Originally Posted by Spencer101 View Post
Hi Anne,

1) Select all the cells you need this done to.
2) Press Ctrl+H to bring up the find and replace box
3) In the "Find What" box just enter a space
4) In the "Replace With" box hold down the Alt key (the one to the left of the space bar) and type 0010 on the numeric keypad (not the numbers along the top of your keyboard)
5) Nothing will show in the replace with box, but the magic will happen as soon as you hit the "Replace All" button.

Let me know if that works or not for you. :)
Hi,
It was magical, but instead of adding the line break, it removed the space between day and date. Do you have any other magic codes that will add a line break?
  #4   Report Post  
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by ASJassie View Post
Hi,
It was magical, but instead of adding the line break, it removed the space between day and date. Do you have any other magic codes that will add a line break?
Worked perfectly for me.
Undo what you did and try it again. Just make sure you hold down Alt whilst you type the 0010 in the second box. You HAVE to use the numerical keypad to the right of your keyboard and not the numbers along the top.

If it still doesn't work, post the workbook and I'll see if I can get it to work for you.
  #5   Report Post  
Junior Member
 
Posts: 4
Smile

Quote:
Originally Posted by Spencer101 View Post
Worked perfectly for me.
Undo what you did and try it again. Just make sure you hold down Alt whilst you type the 0010 in the second box. You HAVE to use the numerical keypad to the right of your keyboard and not the numbers along the top.

If it still doesn't work, post the workbook and I'll see if I can get it to work for you.
Wow!! I copied my sheet onto another sheet and tried again and it worked perfectly!! Thank you very much for that magic trick! Have a great day!


  #6   Report Post  
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by ASJassie View Post
Wow!! I copied my sheet onto another sheet and tried again and it worked perfectly!! Thank you very much for that magic trick! Have a great day!
See! MAGIC ;)

Glad to help.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wrapping a date in excel Joel Excel Discussion (Misc queries) 4 September 6th 12 04:07 PM
Extracting date from Date and Time formatted cell Aviral Sharma Excel Discussion (Misc queries) 2 March 6th 09 06:04 AM
changing date formatted as general number into date format pghio Excel Programming 4 March 2nd 07 06:17 PM
number keep being formatted as date baxu New Users to Excel 2 October 6th 05 02:21 PM
Date Formatted Cells Mike Excel Worksheet Functions 3 December 3rd 04 06:55 PM


All times are GMT +1. The time now is 01:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"