View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
dlw
 
Posts: n/a
Default Unwanted £ signs when exporting data from access into excel

check this setting- In windows, Start / Settings / control panel / regional
options / currency


"Judy" wrote:

I constantly export data from access into excel worksheets but the figure
columns always show a '£' sign even though the format of the access field is
set to 'standard'.

Does anyone know how to resolve this