From: shapper on
Hello,

I have the following number in a cell:
12,892.70

This is recognized as text. I tried to change the cell format to
number and it does not work.
The format should be 12.892,70.

Is there a way to make this change on the Sheet instead of VB?

Thanks,
Miguel

From: Rick Rothstein on
Select the cell or (contiguous) cells (in a column),click Data/TextToColumns
in the menu bar, click Next button twice, then click the Advanced button on
the third dialog page and change the two separator characters to what you
have (comma for decimal and dot for thousands), hit OK, select "General" in
the "Column data format" section and click the Finish button.

--
Rick (MVP - Excel)


"shapper" <mdmoura(a)gmail.com> wrote in message
news:8f70c044-8e24-4629-a9ac-b7e46a255a05(a)h2g2000vbd.googlegroups.com...
> Hello,
>
> I have the following number in a cell:
> 12,892.70
>
> This is recognized as text. I tried to change the cell format to
> number and it does not work.
> The format should be 12.892,70.
>
> Is there a way to make this change on the Sheet instead of VB?
>
> Thanks,
> Miguel
>