Number format

P

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 '.'?
 
J

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 '.'?
Click to expand...

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.
 
P

Peter

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

Peter
 
P

Peter

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

Peter
 
Top