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

Sound like the format on the Excel sheet is set to currency!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Judy" wrote in message
...
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.