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

H

Hugo Rosa

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
 
T

Tyro

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

Tyro
 
T

Tyro

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Substituting CRLF with "+" - Transforming a cell containing numbersin a sum of its numbers 2
Excel VBA - Force 4 commas into a text field on userform 7
Excel won't let me type a formula using commas! 5
Need help with Data Validation Formula for a set of numerical andtext-based values 7
Differences Between Two Spreadsheets ? 1
counting the number of commas within a text string 2
Extracting data from range and placing in one cell with comma'sbetween while ignoring blanks 5
Replace Comma with Hyphen 2

Top