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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hugo Rosa - 12 Mar 2008 18:26 GMT

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

Reply to this Message

Leo Rod - 12 Mar 2008 20:30 GMT

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

Greetings

Leo Rod.

> Hello to ALL.
> I would like to know what should i use as a command or formula on Excel in
[quoted text clipped - 9 lines]
>
> Hugo Rosa

Reply to this Message

Tyro - 12 Mar 2008 20:34 GMT

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

Tyro

> Hello to ALL.
> I would like to know what should i use as a command or formula on Excel in
[quoted text clipped - 9 lines]
>
> Hugo Rosa

Reply to this Message

Tyro - 12 Mar 2008 20:36 GMT

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

> Select the cell with the number. Press Ctrl+1, Custom tab, enter 000","00
> and 43534 will display as 435,34
[quoted text clipped - 15 lines]
>>
>> Hugo Rosa

Reply to this Message

Rate this thread: