| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW DO I SET DATES TO SHOW ON MY SPREADSHEET?
Hi all,
is there any way to show date automatically when i open my excel spreadsheet? for instance, if i exported a file that has 100 rows and 5 columns and save it as *.xls file. When i open the file it will show current date in a new columns? is it possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW DO I SET DATES TO SHOW ON MY SPREADSHEET?
Hello Roberto, Place the forumla =TODAY() in the cell or cells you want to display the date. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=555332 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW DO I SET DATES TO SHOW ON MY SPREADSHEET?
Pls post in only ONE group,
-- Don Guillett SalesAid Software "Roberto" wrote in message ... Hi all, is there any way to show date automatically when i open my excel spreadsheet? for instance, if i exported a file that has 100 rows and 5 columns and save it as *.xls file. When i open the file it will show current date in a new columns? is it possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| zeros show as dashes in spreadsheet, want to show 0. | Excel Discussion (Misc queries) | |||
| Show if between two dates | Excel Discussion (Misc queries) | |||
| Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
| HOW DO I SET DATES TO SHOW ON MY SPREADSHEET? | Excel Worksheet Functions | |||
| HOW DO I SET DATES TO SHOW ON MY SPREADSHEET? | Excel Discussion (Misc queries) | |||
Hybrid Mode
