Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want to display the path of the excel file in the header, but it changed
"&D" into a date. How do I prevent Excel from doing this? |
#2
![]() |
|||
|
|||
![]()
Hi
use &&D instead Cheers JulieD "Mizuchi" wrote in message ... I want to display the path of the excel file in the header, but it changed "&D" into a date. How do I prevent Excel from doing this? |
#3
![]() |
|||
|
|||
![]()
Thank you very much for the reply. I noticed that everything with a & before
it turned into a blank space. Browsing other header options, I borrowed code I didn't know about: &[Path]&[File] This doesn't allow me to show me the mapped network drive letter everyone uses, so I will use your solution instead. Thanks again. "JulieD" wrote: Hi use &&D instead Cheers JulieD "Mizuchi" wrote in message ... I want to display the path of the excel file in the header, but it changed "&D" into a date. How do I prevent Excel from doing this? |
#4
![]() |
|||
|
|||
![]()
you're welcome and thanks for the feedback
"Mizuchi" wrote in message ... Thank you very much for the reply. I noticed that everything with a & before it turned into a blank space. Browsing other header options, I borrowed code I didn't know about: &[Path]&[File] This doesn't allow me to show me the mapped network drive letter everyone uses, so I will use your solution instead. Thanks again. "JulieD" wrote: Hi use &&D instead Cheers JulieD "Mizuchi" wrote in message ... I want to display the path of the excel file in the header, but it changed "&D" into a date. How do I prevent Excel from doing this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can I delete old custom headers in Excel? | Excel Discussion (Misc queries) | |||
Pivot Table - Custom Formulas | Excel Discussion (Misc queries) | |||
How do I make the custom headers and footer repeat on every works. | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
Custom Page Headers | Excel Discussion (Misc queries) |