date formula

B

bill2

Hi,
How do I write formula for a 8 digit date without / so that it appears as a
8 digit number: ie, 2/12/99 as 02121999?
Thanks!
 
R

Rick Rothstein

If you want a formula for use in a different column, use this...

=TEXT(A1,"ddmmyyyy")

If you want to simply change the appearance of your date in the same cell,
use Format/Cell and this Custom format... ddmmyyyy
 

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

Style Heading 2 5
Adding recognised Zeros 5
Word- Find and Replace 1
Display weeks from a Milestone 0
Keep First Letters, with exceptions 0
deleting numbers prefix 3
Improving Macro That Keeps First Letter 0
Delete all data after a symbol in a field 0

Top