View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Melissa Melissa is offline
external usenet poster
 
Posts: 122
Default Dates - Custom - Pos Pay Format

How do I customize a Date

7/18/08

Should look like 07182008 and needs to be recognized as numbers.

Also, on my last questions about extracting the numbers only and filling
with zeros (10 places)

The formula that I was given recognized the data as text and I need it
recognized as numerical also. Can you Help?