| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format in a text string
"Harlan Grove" wrote in message
ps.com... "T. Valko" wrote... ... That's because the TEXT function will only apply number formats. A1 contains the text abc. B1 contains the formula =TEXT(A1,"0;-0;\<0\;\-\-@\-\-") and returns --abc--. At least running Excel 2003 SP1. Which version are you running? [Surely you would have tested this.] I did, but obviously it wasn't extensive enough. I stand corrected! As Rick noted, it works just as well without the slashes: (not extensively tested) =TEXT(A1,"0;-0;<0;--@--") -- Biff Microsoft Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cells based on text string contains | Excel Worksheet Functions | |||
| Format text string | Excel Discussion (Misc queries) | |||
| How do I grab the date from a text string? | Excel Worksheet Functions | |||
| Date format in string | Excel Discussion (Misc queries) | |||
| Convert text string to date | Excel Worksheet Functions | |||
Hybrid Mode
