Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi-line Formatting
Hi, Just wondering if anyone knows how to format a cell for multiline values. E.g. i have a cell formated with "d/m/yyyy". But if i hit Alt+Enter to enter another line in the cell, can i format that text to "d/m/yyyy" as well? I know i can just type in the value correctly, but i would like to have it formatted. Thanks. -- gareth93 ------------------------------------------------------------------------ gareth93's Profile: http://www.excelforum.com/member.php...o&userid=26578 View this thread: http://www.excelforum.com/showthread...hreadid=550916 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi-line Formatting
gareth93 wrote:
Hi, Just wondering if anyone knows how to format a cell for multiline values. E.g. i have a cell formated with "d/m/yyyy". But if i hit Alt+Enter to enter another line in the cell, can i format that text to "d/m/yyyy" as well? I know i can just type in the value correctly, but i would like to have it formatted. Thanks. Use the TEXT() function |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi-line Formatting
Number formatting works with numbers (and dates/times are just numbers).
As soon as you add the alt-enter, you've changed the value from a number to text. You could use Paul's suggestion by putting the date in a different cell (the row above and hide the row???) And use a formula like: =text(a1,"d/m/yyyy")&char(10)&"whateverelseyouwanthere" Make sure you have format|cells|alignment tab|wrap text checked. gareth93 wrote: Hi, Just wondering if anyone knows how to format a cell for multiline values. E.g. i have a cell formated with "d/m/yyyy". But if i hit Alt+Enter to enter another line in the cell, can i format that text to "d/m/yyyy" as well? I know i can just type in the value correctly, but i would like to have it formatted. Thanks. -- gareth93 ------------------------------------------------------------------------ gareth93's Profile: http://www.excelforum.com/member.php...o&userid=26578 View this thread: http://www.excelforum.com/showthread...hreadid=550916 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
strange horizontal line showing accross several columns | Excel Discussion (Misc queries) | |||
Label an average line in a dynamic chart | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |