View Single Post
  #6   Report Post  
Hilary
 
Posts: n/a
Default

Hi BizMark.

As far as I know, no one has set the cells to comma style.

Hilary

"BizMark" wrote:


Dodo Wrote:
?B?SGlsYXJ5?= wrote in
:
-
Nope. No apostrophe.
-

The only other thing I can think of giving this result, is when the
"numbers" are followed by spaces. This you can check too in the
formula
bar.


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)



Did you previously set those cells to "Comma Style"?
If you look next to the icon for "Currency Style", you've got
"Percentage", "Comma" and "Add/Remove Decimal Place".

Once you've set a cell to Currency or Comma Style, even removing the
decimal places leaves that style set, and sets an invisible 'decimal
tab' point.

Try going to Format -- Cells -- Number
Then, select Category as 'Number' and set the required number of
decimal places. This may fix it.

Regards,
BizMark


--
BizMark