PIXNET Logo登入

software

跳到主文

software

部落格全站分類:數位生活

  • 相簿
  • 部落格
  • 留言
  • 名片
  • 7月 20 週四 200620:08
  • how to insert month date year and day of week

I use Win XP Home Edition, SP2, Excel 2003
Can someone inform me how to put Month, date, year and day of the week in
cell. I'd like to insert for example, 05/18/06 Wed
lt;formatgt;lt;cellsgt;lt;numbergt;lt;custumgt;
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • relative-frequency histogram

Can anyone tell me how to plot a relative frequency histogram (using
midpoints). I know how to to make a histogram using the analysis tools, but
can't get Excel to put in plots for midpoints....
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(10)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • How do I change the output value of a drop down box?

I want to create a drop down box that displays a rebar size. upon selection
of the size, in the output cell designated, I would like it to display the
area of that rebar size. I can't use a simple if statement because there are
10 different size and you can only use 7 nested if statement. what can I do?
If your drop down is A1
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(1)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • XL 03 vs XL 97

Is the newer version of XL that much better than 97?
I have a copy of Office '03 Student and Teacher edition, but have never
bothered to install it. Are the improvements in it actually worth the
effort to mess with it?
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(4)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • Conditional Data Validation possible in Excel 2003?

I am trying to set up several data validation drop-down lists that are
conditional based on the selection in a previous cell. I got instructions,
but saw a note that this may not work in Excel 2003. Does anyone know if
this is possible? Let me know if I need to provide more detail on what I'm
trying to do. Thanks!
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(1)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • my password quit working in an excel workbook, help!

I had my password written down for an Excel workbook, so I am sure I had it
right, down to the capital letter. I am now unable to open the workbook. No
one else had access to my computer. What do I do now? Thank you.
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • Macro that filter data

I want to create a command button that will filter specifice product. Could
you please give me sample macro that filter data.
Thanks.
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • Problem saving a spreadsheet

I created an Excel spreadsheet and saved it to a network drive. When other
people edit the spreadsheet and try to save it they get a message saying the
file is set as read only. They are directed to save the file as another name.
The save dialog box comes up and saves the file as a quot;copy ofquot; the original.
If you right click on the file and go to properties the read only attribute
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(0)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • Look up Data from Worksheet within same Workbook

Here's one play using non-array formulas which might also deliver this ..
A sample construct is available at:
www.savefile.com/files/9870225
Multiple search amp; auto-extract rows from 3 sheets based on key charge code
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(4)

  • 個人分類:title
▲top
  • 7月 20 週四 200620:08
  • Inserting Multiple Rows

Is there a way to insert multiple rows at a single time? Let me see if I can
explain.
I have an existing worksheet contain several hundreds rows on data. I want
to insert 16 new rows between each existing row of data. I can do this by
going to each row and inserting the rows but I was hoping there would be a
(繼續閱讀...)
文章標籤

software 發表在 痞客邦 留言(0) 人氣(3)

  • 個人分類:title
▲top
«1...3194319531963197»

個人資訊

software
暱稱:
software
分類:
數位生活
好友:
累積中
地區:

熱門文章

  • (74) Who makes the best pedal mods?
  • (21)why would the space bar not work in excel?
  • (18)aa ab ac....ax ay az....ba bb bc....zx zy zz ?
  • (6)Where is the tick icon in Excel
  • (3)i cannot get favorites in excel 2003
  • (2)=SUMPRODUCT(--(('Access Data'!B$1:aaaa)=$A5))
  • (2)To show quot;0quot; instead of #N/A
  • (1)need help with macros
  • (2) OK, Sold My 89 Les Paul, What Should I Get?
  • (1) Gibson owned by Guitar Center?

文章分類

  • title (6,014)
  • title (5,999)
  • title (6,022)
  • title (5,957)
  • title (4,957)
  • title (3,013)
  • 未分類文章 (1)

最新文章

  • PICS! 2X12 Cab Reviews Mesa vs. Bogner
  • Q's about Korean PRS with P-90's.
  • aNY NEW duncan pickups next year ?
  • Fernandes Ravelle (Dave Kushner)
  • Another SX Tele question
  • GAS got the best of me yesterday....came home with new GEETAR!
  • Neck strength on Vintage ES330's amp; ES335's...
  • Awesome amp sampler site.
  • anyone try a fishman powerbridge?
  • Got My Custom Made Chassis (Pics)

最新留言

    動態訂閱

    文章精選

    文章搜尋

    誰來我家

    參觀人氣

    • 本日人氣:
    • 累積人氣: