Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have data already in cells and I want to set the format to this data. When
I set the format nothing happens unless I click on each cell and then the format becomes active. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This is normal behavior. Simply changing the format of the cell doesn't change
the value of the cell. And since your numbers were actually text, changing the format from Text to Number still leaves those values as text. But you can select an empty cell edit|copy select your range to fix edit|Paste special|check Addition This will coerce the text numbers to number numbers. greg1090 wrote: I have data already in cells and I want to set the format to this data. When I set the format nothing happens unless I click on each cell and then the format becomes active. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Copying excel format from cell to cell | Excel Discussion (Misc queries) | |||
DOS Data in Excel Format with Date and Military Time in same cell | Excel Worksheet Functions | |||
Excel 2002: Format Cell Height/Width | Excel Discussion (Misc queries) |