ExcelBanter - Ecel Date Format to Number

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Ecel Date Format to Number (https://www.excelbanter.com/excel-discussion-misc-queries/185554-ecel-date-format-number.html)

joeb

Ecel Date Format to Number

How do I copy a date "03/28/08" in column "A" to paste as text "032808" in
column "B"?

Kevin B

Ecel Date Format to Number

The following formula will do the trick, just change the cell address to fit
your requirements:

=TEXT(A1,"mmddyy")

The function converts whatever number is in A1 and then formats the number
according to the format mask argument.
--
Kevin Backmann

"joeb" wrote:

How do I copy a date "03/28/08" in column "A" to paste as text "032808" in
column "B"?

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