How to transform a cell value that as no comma like 43534 into 435,34

Hello to ALL.
I would like to know what should i use as a command or formula on Excel in
order to transform a cell value that as no comma like 43534 into 435,34.

Is it possible to do this in Excel?
How can i do it?

I use Excel 2003 SP3.

Thank you in advance for any help.
Best regards,

Hugo Rosa

Leo
Wed Mar 12 14:30:47 CDT 2008

Cell A1: 43534
Write on Cell B1:"=A1/100" -without the quotes.

Greetings

Leo Rod.

"Hugo Rosa" <hugo_renato@hotmail.com> wrote in message
news:eQ8DmYGhIHA.5780@TK2MSFTNGP06.phx.gbl...
> Hello to ALL.
> I would like to know what should i use as a command or formula on Excel in
> order to transform a cell value that as no comma like 43534 into 435,34.
>
> Is it possible to do this in Excel?
> How can i do it?
>
> I use Excel 2003 SP3.
>
> Thank you in advance for any help.
> Best regards,
>
> Hugo Rosa
>
>

Tyro
Wed Mar 12 14:34:46 CDT 2008

Select the cell with the number. Press Ctrl+1, Custom tab, enter 000","00
and 43534 will display as 435,34

Tyro

"Hugo Rosa" <hugo_renato@hotmail.com> wrote in message
news:eQ8DmYGhIHA.5780@TK2MSFTNGP06.phx.gbl...
> Hello to ALL.
> I would like to know what should i use as a command or formula on Excel in
> order to transform a cell value that as no comma like 43534 into 435,34.
>
> Is it possible to do this in Excel?
> How can i do it?
>
> I use Excel 2003 SP3.
>
> Thank you in advance for any help.
> Best regards,
>
> Hugo Rosa
>
>

Tyro
Wed Mar 12 14:36:12 CDT 2008

Correction:
Select the cell with the number. Press Ctrl+1, Number tab, Custom, enter
000","00
and 43534 will display as 435,34


"Tyro" <Tyro@hotmail.com> wrote in message
news:qfWBj.330$p24.6@nlpi061.nbdc.sbc.com...
> Select the cell with the number. Press Ctrl+1, Custom tab, enter 000","00
> and 43534 will display as 435,34
>
> Tyro
>
> "Hugo Rosa" <hugo_renato@hotmail.com> wrote in message
> news:eQ8DmYGhIHA.5780@TK2MSFTNGP06.phx.gbl...
>> Hello to ALL.
>> I would like to know what should i use as a command or formula on Excel
>> in order to transform a cell value that as no comma like 43534 into
>> 435,34.
>>
>> Is it possible to do this in Excel?
>> How can i do it?
>>
>> I use Excel 2003 SP3.
>>
>> Thank you in advance for any help.
>> Best regards,
>>
>> Hugo Rosa
>>
>>
>
>