...doesnt get applied automatically to the values i put in the caption field. Instead i have to look at the string next to the word "Format$" and then format the data myself as i enter it.

Why? Why doesnt it just format it itself?

a.