View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HK@HKHK HK@HKHK is offline
external usenet poster
 
Posts: 1
Default EXCEL dollar sign BUG?

control panel-regional settings-Currency-currency
symbol=SGD$

However,when i open a .csv file containing a dollar
sign "$"
my excel shows US$XXXX.XX

Everytime i open the .csv file, i need to correct the
format to the whole column.

How to fix it?