ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   using "&" in the header (not date autofill) (https://www.excelbanter.com/excel-worksheet-functions/116063-using-header-not-date-autofill.html)

Jentothephils

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.

Bob Phillips

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.




Jentothephils

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.






All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com