Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
# 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
# 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
# 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
# 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
# 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |