# in Function

  • Thread starter Thread starter CIL
  • Start date Start date
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
 
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
 
Hi,
try to use

=text(c2,"#000 0")

hth
regards from Brazil
Marcelo

"CIL" escreveu:
 
You must log in or register to reply here.

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

Slope??? help please!!! 1
How to write Left Function in VB 2
Match function: error due to format? 4
How do I put a blank value in a cell not using "" in a formula 2
Excel Repeating a RAND() function under certain conditions 0
CHANGE TEXT DATE TO NUMERIC DATE 5
Macro with sum function 1
Subtotal Function is Inconsistent 4

Back
Top