If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
# in Function
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 |
#2
|
|||
|
|||
# in Function
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 |
#3
|
|||
|
|||
# in Function
Hi,
try to use =text(c2,"#000 0") hth regards from Brazil Marcelo "CIL" escreveu: 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 |
#4
|
|||
|
|||
# in Function
hi better one
=text(c2,"#### #") "Marcelo" escreveu: Hi, try to use =text(c2,"#000 0") hth regards from Brazil Marcelo "CIL" escreveu: 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 |
#5
|
|||
|
|||
# in Function
Got it,
Thanks wrote in message oups.com... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
numerical integration | integreat | General Discussion | 4 | May 12th, 2006 02:40 AM |
determine if Excel is open | geebee | General Discussion | 11 | January 20th, 2006 09:25 PM |
How to modify function | Kevin | General Discussion | 5 | January 4th, 2006 10:12 PM |
SPELL CURRENCY FUNCTION | Rajesh | Using Forms | 1 | October 1st, 2005 11:04 PM |
Attaching Code | DS | General Discussion | 2 | August 22nd, 2005 11:21 PM |