| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using "&" in the header (not date autofill)
I want my header to say "R&D" but when I type that, it thinks I want R
10/25/2006 (date autofill for &D). how can I prevent this and get an absolute text value for R&D?? thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using "&" in the header (not date autofill)
Try
R&&D -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jentothephils" wrote in message ... I want my header to say "R&D" but when I type that, it thinks I want R 10/25/2006 (date autofill for &D). how can I prevent this and get an absolute text value for R&D?? thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using "&" in the header (not date autofill)
worked perfectly. thanks!
"Bob Phillips" wrote: Try R&&D -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jentothephils" wrote in message ... I want my header to say "R&D" but when I type that, it thinks I want R 10/25/2006 (date autofill for &D). how can I prevent this and get an absolute text value for R&D?? thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I put the day into my header with the date have it change d | Setting up and Configuration of Excel | |||
| date & time format and autofill | Excel Discussion (Misc queries) | |||
| How do I get a "&" to print in a header? | Excel Discussion (Misc queries) | |||
| Date format in Header | Excel Discussion (Misc queries) | |||
| Date Button in Header (Excel 2000) | Excel Discussion (Misc queries) | |||
Linear Mode
