Custom Formatting

  • Thread starter Thread starter Ali
  • Start date Start date
A

Ali

I will like to create a custom format in the cell that when
there is a number from 1-11 it will read as am from 12 - to
24 it read as PM. The must be actual numbers in the cell
not dates.

Thanks in advance for your assistance.
 
This'll show: 11AM and 13PM:
[<12]General"AM";General"PM"

but maybe this is what you really want:
[<12]"AM";[<=24]"PM";"error"
 
Thanks Dave!

Ali
-----Original Message-----
This'll show: 11AM and 13PM:
[<12]General"AM";General"PM"

but maybe this is what you really want:
[<12]"AM";[<=24]"PM";"error"
I will like to create a custom format in the cell that when
there is a number from 1-11 it will read as am from 12 - to
24 it read as PM. The must be actual numbers in the cell
not dates.

Thanks in advance for your assistance.
Click to expand...

--

Dave Peterson
(e-mail address removed)
.
Click to expand...
 
Back
Top