ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Control Box Text Box (https://www.excelbanter.com/excel-discussion-misc-queries/166490-control-box-text-box.html)

Newbeetle

Control Box Text Box
 
Hi,

I think this is going to be an easy one, but my head won't function tonight,

I have a text box from the Control Toolbox, this has been linked to a cell
with a date, but the text box shows the date as a number, I'm trying to see
how I can change this so that the text box format is a date, Ican't for the
life of me see how to do this.

Any help much appreciated.


--
This post was created using recycled electrons!

FSt1

Control Box Text Box
 
hi.
see this...
http://support.microsoft.com/default.aspx/kb/214233

regards
FSt1

"Newbeetle" wrote:

Hi,

I think this is going to be an easy one, but my head won't function tonight,

I have a text box from the Control Toolbox, this has been linked to a cell
with a date, but the text box shows the date as a number, I'm trying to see
how I can change this so that the text box format is a date, Ican't for the
life of me see how to do this.

Any help much appreciated.


--
This post was created using recycled electrons!


Newbeetle

Control Box Text Box
 
Thanks for thank.
--
This post was created using recycled electrons!


"FSt1" wrote:

hi.
see this...
http://support.microsoft.com/default.aspx/kb/214233

regards
FSt1

"Newbeetle" wrote:

Hi,

I think this is going to be an easy one, but my head won't function tonight,

I have a text box from the Control Toolbox, this has been linked to a cell
with a date, but the text box shows the date as a number, I'm trying to see
how I can change this so that the text box format is a date, Ican't for the
life of me see how to do this.

Any help much appreciated.


--
This post was created using recycled electrons!



All times are GMT +1. The time now is 10:20 AM.

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