ExcelBanter - I want to enter 346 without having to hit shift colan for the col.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I want to enter 346 without having to hit shift colan for the col. (https://www.excelbanter.com/excel-discussion-misc-queries/1204-i-want-enter-346-without-having-hit-shift-colan-col.html)

danlinksman

I want to enter 346 without having to hit shift colan for the col.

Gord Dibben

http://www.cpearson.com/excel/DateTimeEntry.htm

Gord Dibben Excel MVP

On Fri, 3 Dec 2004 15:31:02 -0800, "danlinksman"
wrote:

CLR

Format Custom #":"##

Vaya con Dios,
Chuck, CABGx3

"danlinksman" wrote in message
...

Myrna Larson

With, of course, the caveat that the result is not a time, and you can't do
time arithmetic on it.

On Fri, 3 Dec 2004 19:57:41 -0500, "CLR" wrote:

Format Custom #":"##

Vaya con Dios,
Chuck, CABGx3

"danlinksman" wrote in message
...

All times are GMT +1. The time now is 02:46 AM.