Prev: visual c# excel 2007 pivot filter
Next: How to do check for factors in formulas?
From: shapper on 15 Dec 2009 17:47
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 15 Dec 2009 20:21
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
>

 | 
Pages: 1
Prev: visual c# excel 2007 pivot filter
Next: How to do check for factors in formulas?