| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
NumberFormat question
Hi
I'd like to verfiy that the user works with the numberformat "Short Date", but I don't know how to format this. The following function fails: Columns(1).NumberFormat = "Short Date" How to get this work? Many thanks in advance. Tom |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
NumberFormat question
Hi
try Columns(1).NumberFormat = "MM/DD/YY" -- Regards Frank Kabel Frankfurt, Germany "Tom" schrieb im Newsbeitrag ... Hi I'd like to verfiy that the user works with the numberformat "Short Date", but I don't know how to format this. The following function fails: Columns(1).NumberFormat = "Short Date" How to get this work? Many thanks in advance. Tom |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
NumberFormat question
See your last post from yesterday. Never post new since you have same post
before... Regards. Jorge "Tom" escreveu na mensagem ... Hi I'd like to verfiy that the user works with the numberformat "Short Date", but I don't know how to format this. The following function fails: Columns(1).NumberFormat = "Short Date" How to get this work? Many thanks in advance. Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| .numberformat Q | Excel Worksheet Functions | |||
| NumberFormat | Excel Discussion (Misc queries) | |||
| numberformat? | Excel Discussion (Misc queries) | |||
| Numberformat vs string question | Excel Programming | |||
| Numberformat | Excel Programming | |||
Hybrid Mode
