# in Function

C

CIL

Top of the morning.
The below function inserts a space between the last 2 digits of a number.

6789 in a1 becomes 678 9 and aligns on the left of the cell (text).
=TEXT(A1,"#"" ""0")

Now for the dumb question, what does the "#" do and where could I find this
tidbit of information?

Thanks.
cil
 
B

bplumhoff

Hello,

Open Excel help, go to answer wizard, type "number format codes",
select that and go to "Decimal places, spaces, colors, and conditions".

HTH,
Bernd

Excel 2002
 
M

Marcelo

Hi,
try to use

=text(c2,"#000 0")

hth
regards from Brazil
Marcelo

"CIL" escreveu:
 

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

Compare last digit in 5 cells for match 0
LOOKUP function help 6
Table Preferred width is changed when pasting 1
How do I put a blank value in a cell not using "" in a formula 2
If , Mid or right functions or a combination thereoff. 3
Count Blank Cells with Conditions 3
Find/replace using wild cards to insert space between given characters 1
Creating Labels Over 3-Up Image 2

Top