| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unwanted £ signs when exporting data from access into excel
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| New Excel data does not appear in linked Access table | Excel Discussion (Misc queries) | |||
| Send Excel data to Access through button | Excel Discussion (Misc queries) | |||
| MS Excel data reading in MS Access | Excel Discussion (Misc queries) | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
Linear Mode
