Text Problem..PLEASE HELP!

  • Thread starter Thread starter Sami66
  • Start date Start date
S

Sami66

Total Hours:
Total Gross:
Total Deductions:
Highest Net Pay:
Lowest Net Pay:
Average Hours
Worked:
Average Net Pay:

I need to put the above text, exactly as seen into cells on my payrol
spreadsheet. I am really having the problem with the "Average Hour
Worked" cell. I cant get the text to show like it does. It either take
3 lines, or other ways makes it partially disappear on the left.

How do I use the now function to portray the date as Month 99, 999
Thankx AGAIN!!


Any guidance will be GREATLY appreciated!
 
Hi Sami
Type Average Hours, press Alt + Enter
and then type worked.
Go to Format/cells/Alignment and make sure word wrap is
unchecked.

Regards
Michael
 
I have to fit the the words in the cell (or merged cells)

Average Hours
Worked:

to look just like this. I type "Average Hours" then hit <alt> an
<enter> and it looks the way I want it, but as soon as I click out o
the cell, it reverts to one line and only "Average Hours" shows. If
double click the cell, it all shows, but reverts again as soon as
click away from the cell.

WHY?!?!?!?!?! Please advise
Thanks!!!
 
Sami
Say your data is in column A, Go to the column header and
double click on the divider between column A and column B
This should resize the column to show all of your info.
Regards
Michael
 
Back
Top