Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 519
Default To Chip Pearsons

Hello from Steve Dee

4 9298 Converted to 2-Sep-1998

ok the first digit is month ie 9
the second digit is day ie 2

Is it possible please to change around Month and Day to Day and Month
ok now using 9298 will be in this case 9-Feb-1998

Thankyou.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 519
Default To Chip Pearsons

Hello from Steved

ignore I've found a workaround.

Thankyou.

"Steved" wrote:

Hello from Steve Dee

4 9298 Converted to 2-Sep-1998

ok the first digit is month ie 9
the second digit is day ie 2

Is it possible please to change around Month and Day to Day and Month
ok now using 9298 will be in this case 9-Feb-1998

Thankyou.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help using Chip Pearsons code to count cells with color ram Excel Discussion (Misc queries) 6 March 17th 10 01:38 PM
Pearsons skimball Excel Worksheet Functions 4 April 15th 09 07:51 PM
Chip Pearsons "Rowlander" add-in won't install suzie Excel Discussion (Misc queries) 6 September 10th 07 04:47 AM
Chip Pearson or someone Chip Pearson Excel Programming 3 September 18th 03 05:22 AM
For chip about scroll GUS Excel Programming 1 August 22nd 03 06:44 PM


All times are GMT +1. The time now is 08:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"