LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Formatt date from text

I would like to be able to enter a date numerically and have Excel formatt it
with the slashes, ie; fromatt 092207, to 09/22/07. I don't want to have to
enter the slashes just the numeric value. How do I do this?
 
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
formatt to Calculate difference in now() and date in cell, GARDNERGUY Excel Discussion (Misc queries) 1 April 27th 07 04:06 AM
How do I add a zero in front of a text formatt number? p210driver Excel Worksheet Functions 3 November 14th 06 02:41 AM
How do I add a zero in front of a text formatt number of 5000 reco p210driver Excel Worksheet Functions 0 November 13th 06 11:26 PM
How I convert date formatt of dd/mm/yy to mm/yy (not cell format) Gilad Yron Excel Discussion (Misc queries) 1 March 15th 06 08:32 AM
How do you formatt text in Excel to be changed to UPPERCASE? Chopper_Haynes Excel Discussion (Misc queries) 3 January 23rd 06 05:30 PM


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

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

About Us

"It's about Microsoft Excel"