Hello Dear
Try to select range what u want to format.then format cell then time
then desired fromat.
If you are looking this in VBA Macro.Then try to use this.
''
try the inbuilt custom reformatter method.
with regards,
DM
On Wed, Mar 31, 2010 at 5:35 PM, nike wrote:
> Hi Paul Willekens,
> some of the cells are followed by " mm/dd/ hh:mm"(24Hrs ) format
> some of the followed by "mm/dd/ hh:mm AM/PM" i want "mm/dd/
> hh:mm AM/PM".
>
> thx for
Hi Paul Willekens,
some of the cells are followed by " mm/dd/ hh:mm"(24Hrs ) format
some of the followed by "mm/dd/ hh:mm AM/PM" i want "mm/dd/
hh:mm AM/PM".
thx for u r sugesstion and i tried below customize from cell Format
menu.
thanks in adv.
Mynampat (Nike)
On Mar 31, 2:36 am,
Hi Nike,
Maybe I do not see the problem, but let me focus on the solution...
Just select the columns or range of data cells and specify the cell
properties... special format e.g. mm/dd/ hh:mm or whatever you
preference is...
Good luck
Paul Willekens
--
---
