G
Guest
Guest
Dates in excel seem to be a funny thing.
I would like my cell, formatted as a date, to
1) work like say a phone number. When I enter a series of numbers it puts those numbers into the telephone number style
(123)456-7890. How can I enter a series of numbers and have them show up like mm/dd/yy? ie enter 123456 and have them show up as 12/34/56 Is this possible?
How? Help!
2) Can I format a date cell to increase the date by 1 day in that same cell, say by
hitting the "+" sign, or the up arrow or ?
Is this possible? How? Help!
I would like my cell, formatted as a date, to
1) work like say a phone number. When I enter a series of numbers it puts those numbers into the telephone number style
(123)456-7890. How can I enter a series of numbers and have them show up like mm/dd/yy? ie enter 123456 and have them show up as 12/34/56 Is this possible?
How? Help!
2) Can I format a date cell to increase the date by 1 day in that same cell, say by
hitting the "+" sign, or the up arrow or ?
Is this possible? How? Help!