| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF to set cell number style
Hi all,
if I enter =TODAY() into a cell, its format changes into Date. How could my own UDF do the same? I've tried Public Function YESTERDAY() As Date YESTERDAY = DateAdd("d", -1, Now) Application.ThisCell.NumberFormat = "m/d/yyyy" End Function But setting the NumberFormat property inside UDF has no effect. Any way here? Thanks, Jan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why does it only bold the number in red when i apply the % style? | Excel Discussion (Misc queries) | |||
| How to count number of Cell have Strike Through Effect & Bold as font style. | Excel Discussion (Misc queries) | |||
| How to count number of Cell have Strike Through Effect & Bold as font style. | Excel Programming | |||
| Need Number style | Excel Programming | |||
| Accounting Style Number Button | Excel Worksheet Functions | |||
Threaded Mode
