ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel is changing the comma symbol in formulas to a square box ? (https://www.excelbanter.com/excel-discussion-misc-queries/109695-excel-changing-comma-symbol-formulas-square-box.html)

thesillyscot

Excel is changing the comma symbol in formulas to a square box ?
 
Excel won't accept the comma symbol "," in formulas. when I load
spreadsheets with formulas containing commas, it changes them to small square
boxes, it's like it doesn't recognise the comma anymore !! I am using Excell
2003.

Does anyone know why this is happening?

Ian

Excel is changing the comma symbol in formulas to a square box ?
 
Have a look at ToolsAutocorrect Options and see if the comma is being
replaced because of an entry here.

--
Ian
--
"thesillyscot" wrote in message
...
Excel won't accept the comma symbol "," in formulas. when I load
spreadsheets with formulas containing commas, it changes them to small
square
boxes, it's like it doesn't recognise the comma anymore !! I am using
Excell
2003.

Does anyone know why this is happening?




Dave F

Excel is changing the comma symbol in formulas to a square box ?
 
What font are you using in your workbooks? Try changing the font and see if
the commas appear correctly.

Dave
--
Brevity is the soul of wit.


"thesillyscot" wrote:

Excel won't accept the comma symbol "," in formulas. when I load
spreadsheets with formulas containing commas, it changes them to small square
boxes, it's like it doesn't recognise the comma anymore !! I am using Excell
2003.

Does anyone know why this is happening?



All times are GMT +1. The time now is 09:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com