@Big_jax
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.
NikolinoDE
I know I don't know anything (Socrates)
