excel and dates

Occasional Visitor

How do I enter dates  and a money amount into an excel form? 

1 Reply


Format numbers as currency

If you want to display numbers as monetary values, you must format those numbers as currency. 


Format numbers as dates or times

When you type a date or time in a cell, it appears in a default date and time format. This default format is based on the regional date and time settings that are specified in Control Panel, and changes when you adjust those settings in Control Panel. You can display numbers in several other date and time formats, most of which are not affected by Control Panel settings.



Hope I could help you with these information / links.



I know I don't know anything (Socrates)