About Us

Spencer101

Quote:

Originally Posted by ASJassie

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.

ASJassie

Quote:

Originally Posted by Spencer101

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!

Spencer101

Quote:

Originally Posted by ASJassie

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 05:04 AM
changing date formatted as general number into date format	pghio	Excel Programming	4	March 2nd 07 05: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 05:55 PM

Menu

About Us