Number format

[Peter]

I have recently re-installed Access 2000. For my currency format
if I enter 3.50, it appears as £003,50. Please how can I get rid
of the leading zeros and change ',' to '.'?

 

[John W. Vinson]

I have recently re-installed Access 2000. For my currency format
if I enter 3.50, it appears as £003,50. Please how can I get rid
of the leading zeros and change ',' to '.'?

This is probably not something in Access. In Windows select Start... Control
Panel... Regional and Language Options (may be under another menu), and set
the currency format there.

 

[Peter]

Thanks - that sorted it. I changed the decimal separator to '.'
and the leading zeros disappeared without further change. Weird!

Peter

 

[Peter]

Thanks - that sorted it. I changed the decimal separator to '.'
and the leading zeros disappeared without further change. Weird!

Peter