Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want one column on the worksheet to be date and another column to be
accounting, but when I highlight one column and change the style, the style changes for both columns. How do I isolate each column to be a particular style? Sunny |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You have confused Style for Format. I will just tell you how to solve your
problem and not bother to explain the difference. 1) Select the first column; click on the menu item Format, then on Cell 2) In the resulting dialog in the Categories list, select Date; the chose how you want the date to appear (1/1/2008 or 1 Jan 2008, etc) 3) Click the OK button on the dialog Repeat these steps with the next column but use Accounting Come back if you have problems best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "SunnyG" wrote in message ... I want one column on the worksheet to be date and another column to be accounting, but when I highlight one column and change the style, the style changes for both columns. How do I isolate each column to be a particular style? Sunny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Cell Styles - Quick Styles? | Excel Discussion (Misc queries) | |||
How to apply different color on different columns and legends easily? | Charts and Charting in Excel | |||
How can I apply If statement using two row, multi columns | Excel Worksheet Functions | |||
How do I apply conditional formulas across multiple columns? | Excel Worksheet Functions | |||
Possible to apply Autofilter to a subset of available columns? | Excel Discussion (Misc queries) |