L
lud1
Hi,
I have problem with date format. I have created file with two sheets
Data are tranfered from one sheet to the other by macro. The cell H3 i
the first sheet as well as the columne C in the second sheet ar
formated as a date dd-mm-yyyy (format>cell>date). In fact at the firs
glace everything looks OK, however although the above format ofth
cells they are treated as a text not a number calculating days sinc
1900-Jan-0. How in easy way to make them numbers. Regional setting i
my computer is yyyy-mm-dd, but the file will be filled on by severa
people from defferent computers with different settings.
Visible date format in the first sheet should be dd-mm-yyyy, but th
format in the second sheet simple must be a number (to enable transfe
it further), but there is no request for visible format of C column.
I have reviewed all info regarding Dates and Times in Excel created b
Chip Pearson http://cpearson.com/excel/datetime.htm
and tried to use his special macro for date entry, unfortunatel
without success.
Please help me to solve the problem by special macro or setting - don'
know. if macro where it shoud be located.
Thanks for quick and simple reply
lud
I have problem with date format. I have created file with two sheets
Data are tranfered from one sheet to the other by macro. The cell H3 i
the first sheet as well as the columne C in the second sheet ar
formated as a date dd-mm-yyyy (format>cell>date). In fact at the firs
glace everything looks OK, however although the above format ofth
cells they are treated as a text not a number calculating days sinc
1900-Jan-0. How in easy way to make them numbers. Regional setting i
my computer is yyyy-mm-dd, but the file will be filled on by severa
people from defferent computers with different settings.
Visible date format in the first sheet should be dd-mm-yyyy, but th
format in the second sheet simple must be a number (to enable transfe
it further), but there is no request for visible format of C column.
I have reviewed all info regarding Dates and Times in Excel created b
Chip Pearson http://cpearson.com/excel/datetime.htm
and tried to use his special macro for date entry, unfortunatel
without success.
Please help me to solve the problem by special macro or setting - don'
know. if macro where it shoud be located.
Thanks for quick and simple reply
lud