date format

G

Guest

any ideas as to why when I trim a date column I lose the
mm/dd/yy format. The cells go to excel date code. If I
go to check the format in properties it tells me it is
mm/dd/yy. I have to multiply by one or and than subtract
1 to "activate the format.
 
G

Gord Dibben

TRIM is a Text Function.

Changes your date serial numbers to serial text.

=TRIM(A1)*1 with the column formatted as Date will return a date.

Why are you TRIMming a date column? Or do you have other data in the column
also?

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format 10
VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
Date Format 2
Change date format in Excel footer 2
Date Formats 4
How to enter a date in DD-MM-YYYY format 2
Stop Excel Changing Format 4

Top