How can I enter time digits without a separator?
"Geoff" wrote in message
...
"Lee" wrote:
I have cells formatted to show time as 12:45 for example. I want to just
enter either 3 or 4 digits without the hour minute separator. Can this be
done?
Just do a custom format "hhmm".
Format: Cells - Number tab - Select "Custom" in the Category list
box -
type "hhmm" in the Type text box.
Sorry, Geoff, but format controls how numbers are *displayed*, not how they
are *entered* which was what the OP asked. If you use your format and enter
1245, the display will be 0000, as Excel assumes that what you mean is
29/05/1903 00:00:00 (or 1245 days).
--
David Biddulph
|