Dae format

S

SR

how can we convert the date format, suppose I am entering the date as
09/09/2009 using an input box, the macro should take the date as 9/9/2009.

Please help
 
H

Harald Staff

A date is a date is a date. Those two are the very same, september 9th this
year.

HTH. Best wishes Harald
 
H

Harald Staff

Ok, sorry, you're right, Search (and Filter) use an ugly combination of data
and text representation. It is among a few things Excel still doesn't do too
well.

Select the cells and format them as you wish (how to do this depends on
which Excel version you use). This will not alter the real cell content -the
formula bar will still display 09/09/2009 (or 09.09.2009 ?) as it does now.

Best wishes Harald
 

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

macro adding rows 8
Find then highlight in yellow 6
Save Sheets In Different Files 2
Date format. 1
Macro with a memory 1
How many days fall in each month? 4
Sum If and Count If 2
Excel is changing date format incorrectly 7

Top